Ricky,

If you have morefunc.dll (google) there is a TEXTREVERSE() function that
would help:

=TEXTREVERSE(LEFT(TEXTREVERSE(E6),SEARCH("\",TEXTREVERSE(E6),1)-1))

Beege

"ExcelQuestion" <[email protected]>
wrote in message
news:[email protected]...
>
> In cell R1, I have the full file address C:\Documents and
> Settings\user\Desktop\test.xls
> What's the formula to trim it to show just "test.xls"?
> I found this formula but it's written for Last Name, First Name MI (and
> couldn't convert it to this purpose.
> =TRIM(RIGHT(R1,LEN(R1)-IF(ISERROR(FIND(" ",R1,FIND("
> ",R1,FIND("\",R1,1)+2))),LEN(R1),FIND(" ",R1,FIND("
> ",R1,FIND("\",R1,1)+2))-1)))
>
> Any help is greatly appreciated.
>
> Thanks,
> Ricky
>
>
> --
> ExcelQuestion
> ------------------------------------------------------------------------
> ExcelQuestion's Profile:
> http://www.excelforum.com/member.php...o&userid=34059
> View this thread: http://www.excelforum.com/showthread...hreadid=542626
>