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