Would EditReplace work for you?

Replace: Total

With: nothing


Gord Dibben MS Excel MVP

On Tue, 3 Mar 2009 11:11:01 -0800, cware
wrote:

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