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.

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 specialvaluesokesc.

Delete A and B columns.

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


Gord Dibben MS Excel MVP

On Wed, 17 Oct 2007 20:21:27 -0000, 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.

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.

On Oct 17, 4:47 pm, Mike H wrote:
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.

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