J
J.J.
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!
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!