merging data cells

K

kraway

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?
 
J

John James

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