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
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
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
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Or
=LEFT(A1,LEN(A1)-1)
and if it is always Example and followed by a number
=LEFT(A1,7)
OK Thank you