PDA

View Full Version : Solved: Remove part of the data in a cell



Tenspeed39355
03-31-2006, 04:22 PM
Hi there guys. I have downloaded some data and put it in excel ss
The data in column H has the name of the fund and on the next line it has the date. Is there a way to remove the name of the fund and retain the date? If there was only one to remove it would not be a problem. There are 800 rows that need to be changed. I tried to do a text to coumns but that did not work. Thanks for your time with this matter
Max

johnske
04-01-2006, 05:24 AM
Option Explicit
Sub DeleteText()
Columns("H").SpecialCells(xlCellTypeConstants, xlTextValues).ClearContents
End Sub


EDIT: (No response for 12 days so will assume the problem is Resolved)