Pulling just the filename

[Cardinal]

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.

[Bob Phillips]

=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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>

[CLR]

=MID(A1,FIND("/",A1,1)+1,99)

Vaya con Dios,
Chuck, CABGx3



"Cardinal" wrote:

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

[Cardinal]

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.

[CLR]

Or this.......

=MID(A1,FIND("s/",A1,1)+2,99)

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

> =MID(A1,FIND("/",A1,1)+1,99)
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Cardinal" wrote:
>
> > 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.
> >
> >

[Gord Dibben]

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" <[email protected]> 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.

[Bob Phillips]

=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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>

[Ron Rosenfeld]

On 30 Jun 2006 10:21:55 -0700, "Cardinal" <[email protected]> wrote:

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

Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/

Then use the formula:

=REGEX.MID(A1,"(?<=/)[^/]+$")

to return the last string that follows a "/"
--ron

[Harlan Grove]

Ron Rosenfeld wrote...
....
>Then use the formula:
>
>=REGEX.MID(A1,"(?<=/)[^/]+$")
>
>to return the last string that follows a "/"

You don't need the assertion. The following is sufficient.

=REGEX.MID(A1,"[^/]+$")

[Ron Rosenfeld]

On 1 Jul 2006 15:13:20 -0700, "Harlan Grove" <[email protected]> wrote:

>Ron Rosenfeld wrote...
>...
>>Then use the formula:
>>
>>=REGEX.MID(A1,"(?<=/)[^/]+$")
>>
>>to return the last string that follows a "/"
>
>You don't need the assertion. The following is sufficient.
>
>=REGEX.MID(A1,"[^/]+$")

Thanks.
--ron