TRIM, LEFT, RIGHT

[cware]

Can someone tell me how to remove the word Total from each cell in a column?
The word Total is at the end of every cell, and I just want to be able to
remove it with a formula of I am assuming one of the ones in my subject.

Thanks

 

[Niek Otten]

=LEFT(A1,LEN(A1)-5)

Copy down as far as you need

 

[Alan]

=SUBSTITUTE(A1,"Total","")
Regards,
Alan.

 

[Gord Dibben]

Would Edit>Replace work for you?

Replace: Total

With: nothing


Gord Dibben MS Excel MVP