You could try this:

With the list of names in Column A, starting in A2,
Enter the sir names in Row1 of each column, i.e.:
B1 - Smith
C1 - Jones
D1 - Davis
etc.,

Then, enter this formula in B2:

=IF(ISNUMBER(SEARCH(B$1,$A2)),$A2,"")

And copy across as many columns as needed,
Then, select the formula cells in Row 2, and copy down as needed.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"J.J." wrote in message
et...
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!