Pulling just the filename

=MID(A1,FIND("/",A1,LEN(A1)-LEN(SUBSTITUTE(A1,"/","")))+1,255)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Cardinal" <john.menken@ceridian.com> wrote in message
news:1151688115.281108.179980@p79g2000cwp.googlegroups.com...
> I have a column in my spreadsheet that has a bunch of image names and
> paths. Example: images/taapay-040.gif
>
> Is there a way that I can pull out just the filename? This would make
> things so much easier for me and save me a ton of editing. Thank you
> very much.
>

Oh boy, my fault - please forgive me. Your function worked perfectly
although I now realize that I left out one important item. Not all the
paths are the same. They might one level or several levels deep. All of
these are possibilites:

images/taasec-004.gif
data/images/taasec-004.gif

Thanks and sorry for forgetting this in my original post.

If the hyphen is common to all, try Data>Text to Columns with the hyphen as
delimiter.


Gord Dibben MS Excel MVP

On 30 Jun 2006 10:59:15 -0700, "Cardinal" <john.menken@ceridian.com> wrote:

>Oh boy, my fault - please forgive me. Your function worked perfectly
>although I now realize that I left out one important item. Not all the
>paths are the same. They might one level or several levels deep. All of
>these are possibilites:
>
>images/taasec-004.gif
>data/images/taasec-004.gif
>
>Thanks and sorry for forgetting this in my original post.

=MID(A1,FIND("~",SUBSTITUTE(A1,"/","~",LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))))+
1,255)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Cardinal" <john.menken@ceridian.com> wrote in message
news:1151690355.775860.120410@b68g2000cwa.googlegroups.com...
> Oh boy, my fault - please forgive me. Your function worked perfectly
> although I now realize that I left out one important item. Not all the
> paths are the same. They might one level or several levels deep. All of
> these are possibilites:
>
> images/taasec-004.gif
> data/images/taasec-004.gif
>
> Thanks and sorry for forgetting this in my original post.
>