delete a keyword from cells
 

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

delete a keyword from cells
 

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"
--
Gary''s Student - gsnu200846


"Shaz" wrote:

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

delete a keyword from cells
 

Use SUBSTITUTE() function
--
If this post helps click Yes
---------------
Jacob Skaria


"Shaz" wrote:

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

delete a keyword from cells
 

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.

Shaz wrote:

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

--

Dave Peterson