How do I merge the text content of two seperate cells into one?
 

In column A I have names, in column B I have another set of names.
How do I get both sets of names in 1 cell, as a continuous string, with a
space between each string?

=A1&" "&B1
Copy the formula down.
Copy all cells.
Edit--Paste special--Values, OK (to get rid of the formulas)
************
Anne Troy
www.OfficeArticles.com

"Kristine" wrote in message
...
In column A I have names, in column B I have another set of names.
How do I get both sets of names in 1 cell, as a continuous string, with a
space between each string?

Try this:

=A1&" "&B1
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Kristine" wrote in message
...
In column A I have names, in column B I have another set of names.
How do I get both sets of names in 1 cell, as a continuous string, with a
space between each string?

Use a formula in another column, like

=A2&" "&B2

and drag it down.

--
Regards,

Juan Pablo González
Excel MVP

"Kristine" wrote in message
...
In column A I have names, in column B I have another set of names.
How do I get both sets of names in 1 cell, as a continuous string, with a
space between each string?