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

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



Splitting Cells wrote:

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

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


"Dave Peterson" wrote:

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



Splitting Cells wrote:

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

try this

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




On Oct 23, 6:54*am, kimo63 wrote:
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



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

Splitting Cells wrote:

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- Hide quoted text -

- Show quoted text -