Splitting cells

[Splitting Cells]

I have a column of insurance company names, it looks like they did a
sub-total somewhere because there is the word "count" after each name. What
is the best way to remove all the words "count" for each company? example
below

EUROP ASSISTANCE Count
EUROPEISKE Count
EUTO CENTER Count
FALLON COMMUNITY HEALTH Count
FALLON HEALTH & LIFE INSU Count

Thanks, Kimo

 

[Dave Peterson]

Select the range to fix
Edit|replace (or ctrl-h)
Find what: (space character)Count
Replace with: (leave empty)
replace all

 

[kimo63]

Hey Dave thanks for the quick response. I tried it and it didn't work. I
hightlighted the column, followed:

Select the range to fix
Edit|replace (or ctrl-h)
Find what: (space character)Count (typed this in box)
Replace with: (leave empty) (type this in box)
replace all

AMALGAMATED LIFE Count
AMERICAN REPUBLIC Count
AMERIHEALTH Count
ASSURANT HEALTH Count
AUSA LIFE Count
AVI INTERNATIONAL Count
AVMA Count
AVMA GROUP HEALTH & LIFE Count
AXA ASSISTANCE Count
AXA ASSISTANCE USA Count
AXA PPP HEALTHCARE Count

 

[muddan madhu]

try this

=SUBSTITUTE(A1,"Count"," ") & drag it down