LinkBack URL
About LinkBacks
Here, try this one:
=LOOKUP(99^99,--LEFT(MID(A2,FIND(CHAR(149),SUBSTITUTE(A2," ",CHAR(149),LEN(A2)-LEN(SUBSTITUTE(A2," ",""))-4))+1,10),10-{9,8,7,6,5,4,3,2,1,0}))
Here, try this one:
=LOOKUP(99^99,--LEFT(MID(A2,FIND(CHAR(149),SUBSTITUTE(A2," ",CHAR(149),LEN(A2)-LEN(SUBSTITUTE(A2," ",""))-4))+1,10),10-{9,8,7,6,5,4,3,2,1,0}))
Last edited by zbor; 09-03-2010 at 08:27 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks