Extracting a string

[Peter Rooney]

OK, I'm stumped.

I have a series of entries in the form:

Artist - Title.DOC
I can write a formula easily enough to seperate out the artist part
=LEFT(C10,FIND("-",C10)-2)

But I can't for the life of me work out how to extract the title minus the
..DOC extension.
Can anyone help, please?

Thanks in advance

Pete

[Kevin B]

I'm not sure this is the most elegant way of doing it, but it does work.

=LEFT(TRIM(RIGHT(C10,LEN(C10)-FIND("-",C10,1))),LEN(TRIM(RIGHT(C10,LEN(C10)-FIND("-",C10,1))))-4)
--
Kevin Backmann


"Peter Rooney" wrote:

> OK, I'm stumped.
>
> I have a series of entries in the form:
>
> Artist - Title.DOC
> I can write a formula easily enough to seperate out the artist part
> =LEFT(C10,FIND("-",C10)-2)
>
> But I can't for the life of me work out how to extract the title minus the
> .DOC extension.
> Can anyone help, please?
>
> Thanks in advance
>
> Pete
>
>

[Peter Rooney]

Kevin,

Elegant or not, it's exactly what I needed!

Thank you very much :o)

Pete



"Kevin B" wrote:

> I'm not sure this is the most elegant way of doing it, but it does work.
>
> =LEFT(TRIM(RIGHT(C10,LEN(C10)-FIND("-",C10,1))),LEN(TRIM(RIGHT(C10,LEN(C10)-FIND("-",C10,1))))-4)
> --
> Kevin Backmann
>
>
> "Peter Rooney" wrote:
>
> > OK, I'm stumped.
> >
> > I have a series of entries in the form:
> >
> > Artist - Title.DOC
> > I can write a formula easily enough to seperate out the artist part
> > =LEFT(C10,FIND("-",C10)-2)
> >
> > But I can't for the life of me work out how to extract the title minus the
> > .DOC extension.
> > Can anyone help, please?
> >
> > Thanks in advance
> >
> > Pete
> >
> >

[Bob Phillips]

=MID(C10,FIND("-",C10)+2,FIND(".",C10)-FIND("-",C10)-2)

--

HTH

Bob Phillips

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

"Kevin B" <kbackmann@sbcglobal.net.spamBgone> wrote in message
news:1C572E22-D7CF-43A0-8065-6C8399DC0F50@microsoft.com...
> I'm not sure this is the most elegant way of doing it, but it does work.
>
>
=LEFT(TRIM(RIGHT(C10,LEN(C10)-FIND("-",C10,1))),LEN(TRIM(RIGHT(C10,LEN(C10)-
FIND("-",C10,1))))-4)
> --
> Kevin Backmann
>
>
> "Peter Rooney" wrote:
>
> > OK, I'm stumped.
> >
> > I have a series of entries in the form:
> >
> > Artist - Title.DOC
> > I can write a formula easily enough to seperate out the artist part
> > =LEFT(C10,FIND("-",C10)-2)
> >
> > But I can't for the life of me work out how to extract the title minus
the
> > .DOC extension.
> > Can anyone help, please?
> >
> > Thanks in advance
> >
> > Pete
> >
> >

[Peter Rooney]

Bob,

Splendid!

Thank you very much

Pete



"Bob Phillips" wrote:

> =MID(C10,FIND("-",C10)+2,FIND(".",C10)-FIND("-",C10)-2)
>
> --
>
> HTH
>
> Bob Phillips
>
> (replace xxxx in the email address with gmail if mailing direct)
>
> "Kevin B" <kbackmann@sbcglobal.net.spamBgone> wrote in message
> news:1C572E22-D7CF-43A0-8065-6C8399DC0F50@microsoft.com...
> > I'm not sure this is the most elegant way of doing it, but it does work.
> >
> >
> =LEFT(TRIM(RIGHT(C10,LEN(C10)-FIND("-",C10,1))),LEN(TRIM(RIGHT(C10,LEN(C10)-
> FIND("-",C10,1))))-4)
> > --
> > Kevin Backmann
> >
> >
> > "Peter Rooney" wrote:
> >
> > > OK, I'm stumped.
> > >
> > > I have a series of entries in the form:
> > >
> > > Artist - Title.DOC
> > > I can write a formula easily enough to seperate out the artist part
> > > =LEFT(C10,FIND("-",C10)-2)
> > >
> > > But I can't for the life of me work out how to extract the title minus
> the
> > > .DOC extension.
> > > Can anyone help, please?
> > >
> > > Thanks in advance
> > >
> > > Pete
> > >
> > >
>
>
>

[Kevin B]

Yo, Bob!

Thanks for the very cool streamlined follow-up. For some one with marginal
typing skills, less is most definitely more.
--
Kevin Backmann


"Bob Phillips" wrote:

> =MID(C10,FIND("-",C10)+2,FIND(".",C10)-FIND("-",C10)-2)
>
> --
>
> HTH
>
> Bob Phillips
>
> (replace xxxx in the email address with gmail if mailing direct)
>
> "Kevin B" <kbackmann@sbcglobal.net.spamBgone> wrote in message
> news:1C572E22-D7CF-43A0-8065-6C8399DC0F50@microsoft.com...
> > I'm not sure this is the most elegant way of doing it, but it does work.
> >
> >
> =LEFT(TRIM(RIGHT(C10,LEN(C10)-FIND("-",C10,1))),LEN(TRIM(RIGHT(C10,LEN(C10)-
> FIND("-",C10,1))))-4)
> > --
> > Kevin Backmann
> >
> >
> > "Peter Rooney" wrote:
> >
> > > OK, I'm stumped.
> > >
> > > I have a series of entries in the form:
> > >
> > > Artist - Title.DOC
> > > I can write a formula easily enough to seperate out the artist part
> > > =LEFT(C10,FIND("-",C10)-2)
> > >
> > > But I can't for the life of me work out how to extract the title minus
> the
> > > .DOC extension.
> > > Can anyone help, please?
> > >
> > > Thanks in advance
> > >
> > > Pete
> > >
> > >
>
>
>