View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bseeley bseeley is offline
external usenet poster
 
Posts: 4
Default How do I group text from cells into categories

I have cells with ethnic groups that I need to consolidate into broad ethnic
categories. For example, Cambodian, Chines, Filipino, etc into Asian/Pacific
Islander and White, White-Armenian, and White-European into White. This data
is in one column. I think this would be a long IF function, but can't set it
up.

Please help!