LinkBack URL
About LinkBacks
=LEFT(A2,MIN(INDEX(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A2),9^9),0))-1)
Try this in "B2" and
=TRIM(RIGHT(A2,(LEN(A2)-LEN(B2)))) in "C2"
=LEFT(A2,MIN(INDEX(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A2),9^9),0))-1)
Try this in "B2" and
=TRIM(RIGHT(A2,(LEN(A2)-LEN(B2)))) in "C2"
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks