Only the string

[ksilenio]

Hi to every one .I have a string like "Example1" , now how can i get only the "Example" string ,without the number
Thank you for your time
Kostas

[Bob Phillips]

Try this array formula

=LEFT(A1,MIN(IF(ISERROR(1*(MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1))),255,RO W(INDIRECT("A1:A"&LEN(A1)))))-1)

Enter with Ctrl-SHift-Enter

[Tom Jones]

Or

=LEFT(A1,LEN(A1)-1)

and if it is always Example and followed by a number

=LEFT(A1,7)

[ksilenio]

OK Thank you