View Full Version : Only the string
ksilenio
04-25-2020, 11:37 AM
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
04-25-2020, 12:11 PM
Try this array formula
=LEFT(A1,MIN(IF(ISERROR(1*(MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1))),255,ROW(INDIRECT("A1:A"&LEN(A1)))))-1)
Enter with Ctrl-SHift-Enter
Tom Jones
04-25-2020, 12:20 PM
Or
=LEFT(A1,LEN(A1)-1)
and if it is always Example and followed by a number
=LEFT(A1,7)
ksilenio
04-26-2020, 01:52 AM
OK Thank you
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.