Tags Microsoft Excel

Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

0

Subjects>Electronics>Computers

How do you merge multiple cells containing multiple date in excel?

Anonymous

∙ 12y ago

Updated: 11/6/2022

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

Wiki User

∙ 12y ago

Still curious? Ask our experts.

Chat with our AI personalities

Taiga

Every great hero faces trials, and you—yes, YOU—are no exception!

Chat with Taiga

Devin

I've poured enough drinks to know that people don't always want advice—they just want to talk.

Chat with Devin

Rene

Change my mind. I dare you.

Chat with Rene

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?

imp

Trending Questions

Who is the founder of tcs company? Can Lenovo G550 - 2958HJU connects to TV? What weakens the WiFi signal? How do you disassemble a Logitech V220? How do you convert ram files to jpg? How do you put an iPad 2 case on Craigs list? How many gallons to fill a corporate jet? What is interoffice communication? What is the full from of LAN? You have original disc and you have to return that disc within 2 days you tried copy disc n when you run that copied disc or image file of the same still you get the same responce please insert origin? What device receives pictures from afar? What is the full name of eka computer? What is the difference between Microsoft publisher and Microsoft Excel? What are the samsung contractors? How many glasses equal one quart? Who are androids competitors? What is fild? How can an acrobat sparkle? Is the abu zaria post ume results out? Is there a setting in Itunes to export files from a USB Turntable iconvert?

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.

Still have questions?

imp

Resources

Top Categories

Product

Company

Copyright ©2025 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.