Hi, because the filename changes regularly, as well as the file folders' location, I need to trim whatever the filename is after the "\" to result in [filename.xls].
Thanks again,
Ricky


Quote Originally Posted by Toppers
Try:

=MID(R1,FIND("test.xls",R1,1),255)

HTH

"ExcelQuestion" wrote:

>
> 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
>
>