LinkBack URL
About LinkBacks
Maybe this
=LOOKUP(2^15,-LEFT(MID(C2,SEARCH("Multiple Sclerosis ",C2)+LEN("Multiple Sclerosis "),10),{1,2,3,4,5,6,7,8,9,0}))
Or
=SUBSTITUTE(MID(C2,SEARCH("Multiple Sclerosis ",C2)+LEN("Multiple Sclerosis ("),3),")","")
Maybe this
=LOOKUP(2^15,-LEFT(MID(C2,SEARCH("Multiple Sclerosis ",C2)+LEN("Multiple Sclerosis "),10),{1,2,3,4,5,6,7,8,9,0}))
Or
=SUBSTITUTE(MID(C2,SEARCH("Multiple Sclerosis ",C2)+LEN("Multiple Sclerosis ("),3),")","")
Last edited by AlKey; 12-12-2014 at 11:05 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks