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