View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa W Lisa W is offline
external usenet poster
 
Posts: 6
Default 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