LinkBack URL
About LinkBacks
Hi Mike,
To pull the 90...
Try
=--TRIM(RIGHT(SUBSTITUTE(Q24," ",REPT(" ",100)),100))
BTW: This works for me to pull the 32...
=LEFT(REPLACE(Q24,1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},Q24&"0123456789"))-1,""),FIND(" ",Q24)-3)
Hi Mike,
To pull the 90...
Try
=--TRIM(RIGHT(SUBSTITUTE(Q24," ",REPT(" ",100)),100))
BTW: This works for me to pull the 32...
=LEFT(REPLACE(Q24,1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},Q24&"0123456789"))-1,""),FIND(" ",Q24)-3)
Last edited by jeffreybrown; 06-01-2012 at 01:49 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks