Hello All,

I'm having a problem doing something that seems like it would be relatively
simple....I have a value in a cell which is actually the directory path and
name of another workbook (i.e.
\\Server1\clients\clientA\financials\financialstat ement.xls) and I would
like to get just the file name by itself. The name "financialstatements"
will vary, so I will need a function/macro that can take whatever is between
the last "\" and ".xls" and return that value to a cell. I have been unable
to use the right function with the find function because the find function
starts at the beginning of the string and therefore returns the first "\".
Is there a way to start from the end of the string instead of the beginning?
Thanks in advance,

Ashleigh