LinkBack URL
About LinkBacks
Hi Lyndy256,
you can use below formula in Cell B2, & then Copy down till end of your data
=IF(ISERROR(FIND(" ",A2,1)),"",RIGHT(A2,LEN(A2)-FIND("#",SUBSTITUTE(A2," ","#",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))))))
Hi Lyndy256,
you can use below formula in Cell B2, & then Copy down till end of your data
=IF(ISERROR(FIND(" ",A2,1)),"",RIGHT(A2,LEN(A2)-FIND("#",SUBSTITUTE(A2," ","#",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))))))
Click on * below if you find this helpful
Thanks,
A
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks