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