LinkBack URL
About LinkBacks
One way is this
=LEFT(REPLACE(A1,1,FIND("|",SUBSTITUTE(A1," ","|",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1)),""),2)
One way is this
=LEFT(REPLACE(A1,1,FIND("|",SUBSTITUTE(A1," ","|",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1)),""),2)
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks