Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting characters before or after a specific character | Excel Worksheet Functions | |||
extracting specific rows | Excel Discussion (Misc queries) | |||
Extracting specific word in a cell | Excel Worksheet Functions | |||
Extracting specific data from a cell | Excel Worksheet Functions | |||
Pivot Table - Extracting specific data | Excel Worksheet Functions |