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

Copy down as far as you need

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cware" wrote in message
...
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