Good Morning,
I have a list of text in column D. There are about 15000 rows. The vast
majority of the text is just words, however some text is preceeded by a
decimal point and two numerals. I want to get rid of the decimal and
the two numerals but keep the text.
*I have something like:*

apples
pears
.11 oranges
beets
.51 grapes

RESULT:
apples
pears
oranges
beets
grapes

Thanks for the help.


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=471438