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