LinkBack URL
About LinkBacks
probuddha 
Formula for B3.Formula:
=LEFT(A3,LEN(A3)-LEN(C3)-1)
Formula for C3 entered using Ctrl Shift Enter
Formula:=RIGHT(A3, LEN(A3)-MAX(IF(ISNUMBER(VALUE(MID(A3,ROW(INDIRECT("1:" & LEN(A3))),1))),ROW(INDIRECT("1:" & LEN(A3)))))-1)
Then fill down.
Formula for B3.Formula:=LEFT(A3,LEN(A3)-LEN(C3)-1)
Formula for C3 entered using Ctrl Shift Enter
Formula:=RIGHT(A3, LEN(A3)-MAX(IF(ISNUMBER(VALUE(MID(A3,ROW(INDIRECT("1:" & LEN(A3))),1))),ROW(INDIRECT("1:" & LEN(A3)))))-1)
Then fill down.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks