You are currently viewing How to put multiple data in one cell in excel

How to put multiple data in one cell in excel

You can combine more data from different into a single cell. There are many ways we can combine data into one cell, for example, "The ampersand symbol" the CONCAT function.

 

The steps to combine multiple data from different cells into a single cell

1. Open up your workbook.

2. Select the cell you want to put all your data.

3. Type = and select the first cell you wish to combine.

4. Type & and use quotation marks with space enclosed.

5. Select the other cell you want to combine and hit enter. For example =A3&" "&B3.

This works only when you want to combine two cells into one cell.

 

Steps using the CONCAT function.

1. Open your worksheet.

2. Choose the cell you want to combine the data with.

3. Write the formula =CONCAT(.

4. Select the cell you want to combine first.

You use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.

5. Close the formula with a parenthesis and hit enter. An e.g.     might be =concat(A2, "doctors").

If you have more texts and you want them to fit into one cell, it's easy. If you put the whole line into one cell, it will keep going, so what you need is a way to organize your work and fit the actual data into one cell. Mostly is done by wrap text like a paragraph or insert a line break within the cell.

 

Steps on how to wrap the text to fit into a cell.

The only thing you have to do is format the text so that the text will wrap automatically.

1. Right, click within the cell.

2. A menu will pop up.

3. Format cells, a dialog box open, move to the alignment tab, and check the box next to the wrap text.

4. The text within the cell will wrap automatically.

 

Inserting the line break within a cell

The line break will enable you to break every sentence when you want it and how you want them to appear.

1. Type every sentence within the cell.

2. To insert a hard return, press ALT-ENTER. (On a Mac, navigate like CTR-OPTION-ENTER. Or just hit command and enter.

To avoid readability problems, the data in a cell will be aligned at the bottom of the cell Control vertical lines.

3. Select all the cells to align.

4. Right-click and the menu pops up. As it was in the first procedure.

5. Select format cells and then go back to the alignment tab.

6. See the drop-down menu and align all the content within the cell vertically.

That is all, and your data will be clean and readable. To fit all the data into one cell is annoying when you don't know how to wrap text or insert a line breaker. Sometimes it is challenging to copy and paste. That will be the next tutorial on copying and pasting the data within a cell that is embedded with hard returns.