LinkBack URL
About LinkBacks
Suppose that "Teaching Tree:lastname, firstname" is in A1 cell. Then formula would be like that:
=SUBSTITUTE(A1,RIGHT(A1,LEN(A1)-FIND(":",A1,1)),"",1)
Result: Teaching Tree:
Suppose that "Teaching Tree:lastname, firstname" is in A1 cell. Then formula would be like that:
=SUBSTITUTE(A1,RIGHT(A1,LEN(A1)-FIND(":",A1,1)),"",1)
Result: Teaching Tree:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks