If you have two names (first and last) in column A and first in Column B...

You could use a couple of helper formulas:

=LEFT(A1,SEARCH(" ",A1))&"& "&B1
in C1
and
=MID(A1,SEARCH(" ",A1)+1,255)
in D1
and drag both those formulas down the range.

If you want values, just edit|copy, edit|paste special|values.

(And delete the original columns????)

te_butts wrote:

Here is my scenario:
**Column 1** **Column2**
John Doe Jane

And this is what i want it to look like:

**Column1** **Column2**
John & Jane Doe

How would i do that through VBA?
P.S. I have 350 rows that i want to happen to, so manually is something i
really dont want to do. I want to put this in a command button.

Thanks much!

--

Dave Peterson