Trimming a text string in Excel 2000

Hi, can anyone help...I'm sure that this is simple, but I can't figure a way to do it!

I have a workbook with many sheets. On each sheet is a title (in cell C4). I want to assign the title to a variable after trimming the last 25 characters, eg, the first title is "Injection Blow Moulding Machines - Specification Checklist"........my variable needs to be "Injection Blow Moulding Machines".

I've tried trim & right$ functions with no luck. Does anyone know how this can be done (Please!)

Regards,

Mark Lees