View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J.J.
 
Posts: n/a
Default Find Matching Text In Col A move to Col B

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!