Hi

Can anyone help, i am trying to deletel the last word from a Cell

My cell currently read: - M04274059519 Total

and I need a formula that will delete the "total" word

Would really appreciate some help

linexe