LinkBack URL
About LinkBacks
highlystrung 
highlystrung,
Does this need to be VBA? This formula should do the trick
=LOOKUP(2,1/(LEN(--TRIM(MID(SUBSTITUTE(E2," ",REPT(" ",99)),99*(ROW($1:$30)-1)+1,99)))=3),--TRIM(MID(SUBSTITUTE(E2," ",REPT(" ",99)),99*(ROW($1:$30)-1)+1,99)))
highlystrung,
Does this need to be VBA? This formula should do the trick
=LOOKUP(2,1/(LEN(--TRIM(MID(SUBSTITUTE(E2," ",REPT(" ",99)),99*(ROW($1:$30)-1)+1,99)))=3),--TRIM(MID(SUBSTITUTE(E2," ",REPT(" ",99)),99*(ROW($1:$30)-1)+1,99)))
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks