Hello Friends
Need to extract the texts in given links after last `/' by using formula in light yellow cells.
Thanks in advance.
Hello Friends
Need to extract the texts in given links after last `/' by using formula in light yellow cells.
Thanks in advance.
Sekar
C3=TRIM(RIGHT(SUBSTITUTE(B3,"/",REPT(" ",LEN(B3))),LEN(B3)))
OR
C3=REPLACE(B3,1,SEARCH("^",SUBSTITUTE(B3,"/","^",5)),"")
Try any one of above and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Finally i got what i want thankyou.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks