Try this formula...

=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",99)),99))

--
Rick (MVP - Excel)


"Lisa W" wrote in message
...
I am trying to separate the last set of text in a long url address. I
tried
=TRIM(RIGHT(A1,FIND("/",A1)+1)) and only got part of the text I need. I
have
about 1000 lines of different url's that I want to do this to so wondering
if
there's a way. Below is an example:

http://chs.com/US/NATIONAL/KDSDR.NSF/53c9f3d7e14ba67e85256c7d005753cc/281e54422921e0a985256d1a000162cf/$FILE/Submission
Form-Tax Record - 2008-02-01.doc

Thanks, Lisa