Hi Casey

With your data in column A, enter in B1
=IF(NOT(ISERROR(FIND(" ",A1))),MID(A1,FIND(" ",A1)+1,255),A1)
Copy down column B

Regards

Roger Govier


Casey wrote:
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.