delete a keyword from cells

[Shaz]

"Total" is the last word in each cell. How do I get rid of it?

 

[Gary''s Student]

Say the cells are in column A, in an un-used column enter:

=SUBSTITUTE(A1,"Total","") and copy down

You could also use a macro to do the same thing "in place"

 

[Jacob Skaria]

Use SUBSTITUTE() function

 

[Dave Peterson]

Select the range to fix
Edit|replace
what: Total
with: (leave blank)
replace all

And I bet you want a space character in front of that Total string.