Eliminate last word in a string

C

Chris

I have a long list of names that all contain the
word "count" at the end of the string. Example: "XYZ
Company Payment Count" I need to eliminate the "Count"
from all the rows in the column. Thanks for your help.
 
F

Frank Kabel

Hi
have you tried to use 'Edit - Replace'. Or is the last word different
in each row?
 
C

Chris

I can't Edit-Replace because each row is a different
string of words the only word that is the same is the very
last one, "Count".
 
F

Frank Kabel

Hi
use the following formula in a helper column:
=TRIM(SUBSTITUTE(A1,"Count",""))
and copy down for all rows

or simply use Edit - Replace. As search value enter:
' Count'
(without the apostrophes)
and leave the Replace box empty
 
Top