Splitting cells

S

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
 
D

Dave Peterson

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

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
Click to expand...

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
 
Top