Hi Toppers,
Good to know how the "#" works. Thanks for your help.

Ricky

Thanks also to Kevin for the array formula and additional information. I've made notes for future reference.


Quote Originally Posted by Toppers
Ricky,
The last "\" in the file path is substituted by the "#" which
is then used by the FIND function to get the start position (+1) of the file
name; the "#" could be replaced by another character which will not occur in
the file path.

HTH

"ExcelQuestion" wrote:

>
> Thanks Toppers,
> This formula is what I'm looking for. (No idea how the "#" fits into
> this equation to make it work though. Could you please explain for
> future reference? Thanks again.
>
> Begee,
> I checked out the Reversetext command. Good to know.
>
> Thanks,
> Ricky
>
>
> Toppers Wrote:
> > TRY:
> >
> > =MID(A1,FIND("#",SUBSTITUTE(A1,"\","#",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))+1,255)
> >
> > "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
> > >
> > >
>
>
> --
> ExcelQuestion
> ------------------------------------------------------------------------
> ExcelQuestion's Profile: http://www.excelforum.com/member.php...o&userid=34059
> View this thread: http://www.excelforum.com/showthread...hreadid=542626
>
>