Extract text from a string of text

Hi,

Can anyone advise me how I would extract text from a string of text e.g. I want to extract the first part of the text up until the – sign and also exclude the space before it

e.g.

NRB - LNG-LIC the expected output would be NRB

TRM ELECTRIC - BSG-INFS the expected output would be TRM ELECTRIC

TRM GAS - TRM-ASMN-ENI the expected output would be TRM ELECTRIC


Any assistance would be greatly appreciated


Many thanks in advance

Rob

hlpplease,

Many thanks for your very prompt reply it worked a treat

Thanks again

Rob