Isolate text in a long url
Thanks for all your suggestions - I tried out
=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",99)),99))
and it worked so I didn't try out the other suggestions.
No surprise to Harlan but I am extremely grateful! Allowed me to do
something impressive to my bosses and save quite a bit of time.
Thanks again, Lisa
|