Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
=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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
huge amount of text in merge cell - want undone! | Excel Discussion (Misc queries) | |||
I need to merge text from an Excel doc. into a powerpoint slide? | Excel Discussion (Misc queries) | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Need to convert text string to seperate cells | Excel Worksheet Functions |