Do you know how to combine text from two or more cells into one cell in Microsoft Excel? This is a very useful skill. In this post, MiniTool Software will introduce two ways to combine text in Excel. In addition, if you want to recover your lost Excel files, you can try MiniTool Power Data Recovery.

How to Combine Two Columns in Excel?

If you need to use Microsoft Excel to make a worksheet, you’d better master some Excel skills. For example, you may need to combine cells in Excel. This usually means you need to combine text from two or more cells into one cell.

If you directly merge the target cells, only the text in the left top cell will be kept. Any other text will be removed. Is it possible to combine cells in Excel? Of course, yes. There are two ways. The first way is to use the Ampersand symbol (&), and the other way is to use the CONCAT function.

How to Merge or Unmerge Cells in Excel (without Losing Data)?
How to Merge or Unmerge Cells in Excel (without Losing Data)?

Do you know how to merge or unmerge cells in Excel without losing data? In this article, we will show you some useful guides.

Read More

In this post, we will introduce these two ways in detail.

Way 1: How to Combine Text/Data in Cells Using the Ampersand Symbol (&)

Step 1: Select the cell where you want to save the combined data or text.

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

Step 3: Type & and then use quotation marks with a space enclosed. So, the formula of this section is &" ".

Step 4: Select the next cell you want to combine, then press Enter. An example Excel formula is =A2&" "&B2.

combine two cells in Excel

If you want to combine more cells, you need to repeat the formulas according to the rule.

combine three cells in Excel

Here, if you don’t need the space between two words from different cells, you should not type the space between quotation marks.

no space between quotation marks

After you use one group of formulas in one cell, you can drag the formula to other cells in the same row.

drag the formula to copy it to other cells

Way 2: How to Combine Text/Data in Cells Using the CONCAT Function

You can also use Excel concatenate to combine text in cells. Here is how to use this method to do this job:

Step 1: Select the cell where you want to save the combined data or text.

Step 2: Type =CONCAT(.

Step 3: Select the first cell you want to combine.

Step 4: Type commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.

Step 5: Select the second cell you want to combine.

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

use CONCAT function to combine text in cells

Likewise, you can drag the cell to the following ones to copy that formula. This will save a lot of time for you.

How to Show or Hide Formulas in Microsoft Excel?
How to Show or Hide Formulas in Microsoft Excel?

Do you know how to show or hide formulas in Microsoft Excel? This post will briefly introduce some easy and effective methods you can try.

Read More

How to Recover Your Missing Excel Files?

You may delete or lose some Excel files when using your computer. If so, you can use MiniTool Power Data Recovery to get them back. This is a free file recovery tool that can work on all versions of Windows.

Free Download

How to Recover Deleted Excel Files in Windows and Mac Easily
How to Recover Deleted Excel Files in Windows and Mac Easily

Do you know how to recover deleted excel files in Windows and Mac? In this post, we show you multiple solutions that are based on different situations.

Read More

Bottom Line

How to combine cells in Excel? How to combine text from two or more cells into one cell? This post introduces two easy ways to for you. You can select one according to your situation.

  • Linkedin
  • Reddit