LinkBack URL
About LinkBacks
Try this
=LEFT(A1, FIND("^", SUBSTITUTE(A1," by ","^",(LEN(A1)-LEN(SUBSTITUTE(A1," by ","")))/4))-1)
note there are spaces to each side of by inside the quotes
Try this
=LEFT(A1, FIND("^", SUBSTITUTE(A1," by ","^",(LEN(A1)-LEN(SUBSTITUTE(A1," by ","")))/4))-1)
note there are spaces to each side of by inside the quotes
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks