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