Hi

in an adjacent column
=--(TRIM(SUBSTITUTE(A1,"Total","")))
Copy down as required
--
Regards
Roger Govier

"cware" wrote in message
...
I have a column that each cell ends with the word "Total". I need to
convert
that column to remove that word from each cell. If I need to add a column
to
do that, that's fine, I just cannot figure out how. Can anyone help me on
this one?

Thanks