Perfect!

Thanks very much, your awesome!

As i am looking at the results, some of the cells are not in the correct
format for this to work for all of them, but it's far better then what i had.

Thank you Dave.

"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!