Try:

=IF(ISNUMBER(LEFT(A1)*1),MID(A1,FIND(" ",A1)+1,1024),A1)

HTH
Jason
Atlanta, GA

-----Original Message-----
Howdy All,

I am trying figure out a way to remove the front
portions of a cell if
the cell starts with numbers. If it doesn't I just want
to copy the
text.

I have the function to remove the numbers(well actually
up to the first
space) but it works for what I want.

=TRIM(MID(C2,FIND(" ",C2),LEN(C2)-FIND(" ",C2)))

But I can't figure out a way to do this without using
VBScript and the
client doesn't want that enabled in the files.

Is there any function in Excel that will tell you if a
character is
numeric or not? If so then I could do it with an inline
IF statement
but I haven't been able to find one.

Thanks

dbl

.