"Total" is the last word in each cell. How do I get rid of it?
G Gary''s Student Apr 16, 2009 #2 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"
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"
D Dave Peterson Apr 16, 2009 #4 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.
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.
