Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I been searching for but can't find the answer to this question.
I have a list of names in column A: Jim Jones Jane Smith Barney Todd Davis Pete Smith Ron Jones etc. Is there a function that I can use that would search for "Smith" names and move them to Column B then perhaps using a macro repeat and have all "Jones" names moved to Column C so that eventually I would end up with - Col A Col B Col C Todd Davis Jane Smith Barney Jim Jones Pete Smith Ron Jones I would greatly appreciate any help with this! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find text and copy and move row containing it | Excel Discussion (Misc queries) | |||
Find last occurance of character in text string | Excel Worksheet Functions | |||
Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
Find matching records in two worksheets | Excel Discussion (Misc queries) |