Thread: Splitting cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Splitting Cells Splitting Cells is offline
external usenet poster
 
Posts: 1
Default 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