You don't need a macro, try:-

=concatenate(a1," ",a2)

or

=A1 &" " & B1

Mike


"Myke" wrote:

Hey all,

This is probably simpler than I think but then again I am a newbie at
macros or anything programming related.

What I am looking for is an Excel macro that joins (not merges) data
from two cells in different columns. So, basically the opposite of
Text to columns. And I need it to do this for as many rows as needed
until there is nothing left to join. Below is an example:

Column 1 Column 2

23 Whatever St. Suite 2
87 Nowhere Rd. #201

So, now I just want column 1 to read:

23 Whatever St. Suite 2
87 Nowhere Rd. #201

This would be a huge help so thank you to all in advance.