Hi,
How can I take characters up to the special sign i have in column "A".
I using left formula to take the 1st five digit, but I would like to set the formula to take all digits up to the special character (-)
Thanks
Hi,
How can I take characters up to the special sign i have in column "A".
I using left formula to take the 1st five digit, but I would like to set the formula to take all digits up to the special character (-)
Thanks
Try this: =TRIM(LEFT(A2,FIND("-",A2)-1))
Click the * to say thanks.
Please try B2
=LEFT(A2,FIND("-",A2)-1)
or
=LEFT(A2,FIND(" -",A2)-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks