lundi 30 mars 2015

Get value after end of last / in excel using formula

i want to get the last value after / in excel.



http://ift.tt/1ylRXwm
http://ift.tt/1OInPFZ
http://ift.tt/1ylRVEX


from the above link i want to separate the pagename for eg. from 1 url output should be www.google.com/new/ 2nd http://ift.tt/19o4gCe and so i used RIGHT formula but we can define only static. pls. provide if any one has the solution.


Aucun commentaire:

Enregistrer un commentaire