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