Join cell data in two columns

[Myke]

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.

 

[Gord Dibben]

You don't need a macro to do this.

=A1 & " " & B1 entered in C1

Double-click on fill handle of C1 to fill down.

Select Column C and copy then edit<paste special>values>ok>esc.

Delete A and B columns.

If you want to use a macro, use the macro recorder to get code.


Gord Dibben MS Excel MVP

 

[Guest]

You don't need a macro, try:-

=concatenate(a1," ",a2)

or

=A1 &" " & B1

Mike

 

[Myke]

You don't need a macro, try:-

=concatenate(a1," ",a2)

or

=A1 &" " & B1

Mike

Awesome. See, I knew it had to be simple but I wasn't finding it on
Google. Thanks guys.