I want to merge 2 columns of data into 1 but I want to keep the all the data.
Lets say column A contains "Mr" and column B contains "Jones", I want the
result to be in column C "MR Jones".

Any help?

try this, which adds a space between the two cells' contents

=A1&" "&B1


"kraway" wrote:

I want to merge 2 columns of data into 1 but I want to keep the all the data.
Lets say column A contains "Mr" and column B contains "Jones", I want the
result to be in column C "MR Jones".

Any help?

Say the first cells are A1 and B1. I assume there are values, not
formulae in the two columns, and that you want a space inserted between
them as was the case in your example. In C1 (insert column if
necessary), enter the formula:
=A1&" "&B1

Copy this formula down column C for all of the data area. Then copy
this column of data and Edit-Paste-Special-Values over the top of the
entries in Column C, and then delete Columns A & B.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=528524