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)

 

[Peter Rooney]

Kevin,

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

Thank you very much )

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)

 

[Peter Rooney]

Bob,

Splendid!

Thank you very much

Pete

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

Yo, Bob!

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