How to Combine Text from Two or More Cells into One Cell? - MiniTool

In Microsoft Excel, how to merge text from two or more cells into one cell? This is a very practical technique! This article will introduce two ways to merge text in Excel. Also, if you need to recover lost Excel files, you can try MiniTool Power Data Recovery.

How to merge two columns in Excel?

If you need to use Microsoft Excel to create worksheets, it is best to master some Excel tips. For example, you might need to merge cells in Excel. This usually means you need to merge text from two or more cells into one cell.

If you merge the target cells directly, only the text in the upper left cell is preserved. Any other text will be deleted. So, how to merge cells in Excel? Of course, there are two ways. The first method is to use the & sign (&), and the other method is to use the CONCAT function.

This article will introduce these two methods in detail.

Method 1: How to merge text/data in a cell using & number (&)

Step 1: Select the cell to save the merged data or text.

Step 2: Type = and click the first cell you want to merge.

Step 3: Type & and use quotes with spaces. Therefore, the formula for this part is &" ".

Step 4: Select the next cell to merge and press Enter . An example Excel formula is =A2&" "&B2 .

If you want to merge more cells, you need to repeat the formula according to the rules.

Here, if you don't need spaces between two words in different cells, you should not type spaces between quotes.

After using a set of formulas in one cell, you can drag the formula to other cells in the same row.

Method 2: How to merge text/data in cells using CONCAT function

You can also use Excel's CONCAT function to merge text in cells. Here is how to do this using this method:

Step 1: Select the cell to save the merged data or text.

Step 2: Type =CONCAT( .

Step 3: Select the first cell to merge.

Step 4: Type a comma to separate the cells you want to merge and add spaces, commas, or other text using quotes.

Step 5: Select the second cell to merge.

Step 6: Close the formula with brackets and press Enter . An example Excel formula is =CONCAT(A2&" "&B2) . You can see this helps you merge text in Excel.

Similarly, you can drag the cell to the cell below to copy the formula. This will save you a lot of time.

How to recover lost Excel files?

When using a computer, you may delete or lose some Excel files. If so, you can use MiniTool Power Data Recovery to recover them. This is a free file recovery tool that can be run on all versions of Windows.

Summarize

How to merge cells in Excel? How to merge text from two or more cells into one cell? This article introduces two simple methods for you to choose from, and you can choose one of them according to your situation.

The above is the detailed content of How to Combine Text from Two or More Cells into One Cell? - MiniTool. For more information, please follow other related articles on the PHP Chinese website!