TRIM, LEFT, RIGHT

  • Thread starter Thread starter cware
  • Start date Start date
C

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
 
Would Edit>Replace work for you?

Replace: Total

With: nothing


Gord Dibben MS Excel MVP
 
Back
Top