answersLogoWhite

0


Best Answer

If you merge cells into one cell, the data from the first cell is retained and all other data in the other cells is lost. To get data from lots of cells into another cell you can concatenate them, using the & or the CONCATENATE function. So to combine the contents of cell A1 and B1, to be shown in C1, you could do this:

=CONCATENATE(A1,B1)

or

=A1&B1

To put a space between the contents of the two cells then you would change it slightly, like these:

=CONCATENATE(A1," ",B1)

=A1&" "&B1

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you merge multiple cells containing multiple date in excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What command combines a range of cells into one cell that occupies the same amount of space in excel?

The name is "merge and center", which combines all highlighted cells. For newer versions of Excel this is on the "Home" tab.


How do you merge cells into single cell in Excel?

Highlight the cells you are interested in merging .. make sure you are on the "home" tab (found at the top of the excel program), and choose the down arrow beside merge & center in the "alignment box". there you will find the option to merge & center, merge across, merge cells, and unmerge cells ..


What command combines cells into one larger cell?

In Excel, you can use the CONCATENATE function to combine cells into one larger cell. Alternatively, you can use the "&" symbol to achieve the same result. Both methods allow you to merge the content of multiple cells into a single cell.


What is used to combine cells together in the program excel?

You can use the Merge and Center icon on the formatting toolbar or do it through the Format menu by going to Cells and then picking the Merge cells option.


How do you merge and center the selected cells in excel?

Highlight the cells you want to merge by left clicking, holding and dragging until all the cells are identified. At the top of the screen there should be an icon that looks like a square with two arrows pointing left and right; in older versions of Excel the icon says "Merge and Center". Once your cells are highlighted, click on this icon and the cells will merge and any data entered into the merged cell will be centered.


What is the function of the Merge Cells option?

The function of the merge cells option is to combine multiple cells in a table. This merging can take place for different reasons such as addition.


What combines a range of cells into one cell that occupies the same amount of space in an excel worksheet?

The Merge Cells option.


How do you align text over several columns or rows in Excel?

Select the cells you want and then use the Merge and Center icon on the formatting toolbar, or go to the Format menu, pick Cells, Alignment and Merge Cells.


How do you adjoin two cells in Excel?

If you have 2007, go to the ribbon "Home" and click on "Merge". This will only take the first cell's information.


How do you merge and center in Microsoft excel?

First select the cells you want to Merge and Center. Then there are two ways. You can go to Format Cells and then Alignment and the option is there. You can also do it by clicking on the icon on the Formatting toolbar.


How do you merge and center in Microsoft Excel 2003?

First select the cells you want to Merge and Center. Then there are two ways. You can go to Format Cells and then Alignment and the option is there. You can also do it by clicking on the icon on the Formatting toolbar.


How do I retain Excel cell formatting during mail merge into a table in Word?

Merge brings one to several individual cells from Excel into Word. The formatting in the merged Word document depends on Word, not Excel. If you would like to retain the same formatting as you had in Excel, then format the target location in Word to match the cell from Excel.