software

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

Any help?

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

=A1amp;quot; quot;amp;B1quot;krawayquot; wrote:

gt; I want to merge 2 columns of data into 1 but I want to keep the all the data.
gt; Lets say column A contains quot;Mrquot; and column B contains quot;Jonesquot;, I want the
gt; result to be in column C quot;MR Jonesquot;.
gt;
gt; 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:
=A1amp;quot; quot;amp;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 amp; B.--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=528524