View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wynand wynand is offline
external usenet poster
 
Posts: 54
Default extracting specific rows

Looking for help with the following:

Numeric and non numeric data is in A2:F1580, A1:F1 is the header row.
Column C has different names and surnames in one cell, separated by a space.
Some cells have only names, some cells have names, middlenames and surnames
and some have only names and surnames. I would like to extract rows to
another sheet where cells in column C do either have only one name or more
than one name.
Any ideas in terms of a macro or function?

Regards