How to merge the contents of two Excel cells into one cell

Merging the contents of multiple cells into a single cell usually means copying the contents manually and pasting them into the same cell. But this operation is more troublesome.

Here are a few different ways to merge multiple cells into one cell. Use the Justification function below to fill this method when the content to be merged is full of text and does not contain numbers or formulas.

1.Start by putting the content you want to merge in the same column. Sometimes the content will be in one line, and this is where you need to transpose it.

2.Adjust the column width to ensure that the length of the merged content can be placed in one cell. There are 6 words after merging here, so the column is made larger.

3.Select the target cell and click "Fill".

4.In the drop-down menu, select the "Align at both ends" option. The contents will then be merged into the same cell.

Using this method is to pay attention to ensure the width of the column, otherwise the following content cannot be merged, and there can be no numbers or formulas, otherwise it will not take effect, and there will be a pop-up prompt.

In Excel, sometimes you need to merge the contents of two cells into one cell, then you can use the following methods (take Excel2010 as an example):

3. If you want to display the result more reasonably, you can add other characters to separate the original content, for example, enter **[c3&] in the insert function column"("&d3&")"], the result is displayed as follows:

The function to merge the contents of a cell is concatenate, which can also be used.

and sign) operator.

1. Definition of the concatenate function.

Merge several text strings into a single text string.

Grammar. concatenate

text1,text2,..

text1,text2,..For.

Arrive. text items that are to be combined into a single text item. These text items can be text strings, numbers, or references to individual cells.

Illustrate. It can also be used.

ampand) operator instead of a function.

concatenate

Implement the merging of text items.

2. Suppose you want to merge the contents of two cells A1 and B1 in cell C1, then.

C1 cell is written to the formula.

concatenate(a1,b1)

Or. a1&b1

Merge two cells, only delete the lower row or the right column, otherwise the data will be lost. Examples:

A1 and A2 are merged, and the data inside is combined.

25, select C2, mail, delete, whole line, 25 is still there; If c1 is selected, right-click to delete the entire line, and 25 is gone.

concatenate()

Enter the content you want to merge in parentheses, separated by a comma in English.

In Excel, the method of merging the contents of two cells into one cell is as follows (take WPS Excel as an example): Rulers

1. Tools Raw Materials:

Dell Inspiron 7490, Windows 10, WPS Office 2020.

Second, the specific steps:

1. Click the equal sign: select a blank cell and enter the equal sign "=".

2. Click the first cell: select the first cell after the equal sign.

3. Input and symbols: Find the and "&" symbol in the keyboard and enter.

4. Click the second cell: Select the content of the second cell of the page.

5. Click Enter: After the formula is written, click the input " " small mark in the toolbar.

6. Display result: The interface will display the merge result.

Procedure Method.

1.Open the ** that needs to be merged, and click the tab above to select all columns.

2.Select all and press Ctrl+C to copy the content.

3.Once the copy is complete, paste it in the blank space of another table to merge**.

4.According to the above steps, you can merge the ** content together in Excel.

Precautions Summary.

1.Copy the contents of a **. 2.Paste into the blank space of another **.

In Excel, the method of merging the contents of two cells into one cell is as follows (take WPS Excel as an example): Rulers

1. Tools Raw Materials:

Dell Inspiron 7490, Windows 10, WPS Office 2020.

Second, the specific steps:

1. Click the equal sign: select a blank cell and enter the equal sign "=".

2. Click the first cell: select the first cell after the equal sign.

3. Input and symbols: Find the and "&" symbol in the keyboard and enter.

4. Click the second cell: Select the content of the second cell of the page.

5. Click Enter: After the formula is written, click the input " " small mark in the toolbar.

6. Display result: The interface will display the merge result.