TRIM, LEFT, RIGHT
 

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

TRIM, LEFT, RIGHT
 

=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

TRIM, LEFT, RIGHT
 

=SUBSTITUTE(A1,"Total","")
Regards,
Alan.
"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

TRIM, LEFT, RIGHT
 

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