Merging two columns of data

[JustMe602]

I have 2 columns of data.

I would like to merge the contents but I don't want to erase any of the data in either one of them.

Can I do this easily?


Thanks.
JustMe.

[Jonathan Cooper]

use a helper column.

assuming you want to merge a1 with b1 (and a space in the middle), use the
following formula.

=A1&" "&B1
or
=concatenate(a1," ",b1)



"JustMe602" wrote:

>
> I have 2 columns of data.
>
> I would like to merge the contents but I don't want to erase any of the
> data in either one of them.
>
> Can I do this easily?
>
>
> Thanks.
> JustMe.
>
>
> --
> JustMe602
> ------------------------------------------------------------------------
> JustMe602's Profile: http://www.excelforum.com/member.php...o&userid=27854
> View this thread: http://www.excelforum.com/showthread...hreadid=498801
>
>

[SteveG]

Assuming your data is in A:A and B:B. In cell C1,

=CONCATENATE(A1,B1)

Copy down the column.

Cheers,

Steve

[JustMe602]

Thanks.


JustMe.

[JustMe602]

Is there a way to actually move the data without a formula...

Cause I want later to seperate them out again.

So what I need to do is pull the information back together then put the from in one column and the to in another column. As well as the first part the identifier of the information.