How to Merge Text Cells in Excel (9 Simple Methods)

Sometimes we need to combine Excel text cells to make it more sense or to analyze data correctly. In this article, we’ll show you the effective ways to Merge Text Cells in Excel.

To make it easier for you, we will use the following example. Here, we have separated the Microsoft Services into two text cells. Now, we’ll show you how to Merge these Text Cells in Excel with our proposed methods.

excel merge text cells


Download Practice Workbook

Download the following workbook to practice by yourself.


9 Simple Methods to Merge Text Cells in Excel

1. Excel ‘Merge & Center’ Feature to Combine Text Cells

Excel provides many useful Features to perform variations operations. Here, we’ll use the ‘Merge & Center’ feature to merge text cells in Excel. But this feature returns the upper-left value only and ignores other values. The steps are given below to use this feature.

STEPS:

  • First of all, select cell C4.

Excel ‘Merge & Center’ Feature to Merge Text Cells

  • Next, select the ‘Merge & Center’ option from the Alignment group under the Home tab.

Excel ‘Merge & Center’ Feature to Merge Text Cells

  • Here, a dialogue box will pop out with a warning.
  • Now, press OK.

  • After pressing OK, it’ll return the merged cell with the upper-left value only.


2. Merge Text Cells with Excel CONCAT Function

In this method, we’ll use the Excel CONCAT function to Merge Text Cells without losing any data.

STEPS:

  • First, select cell and D4 type the formula:
=CONCAT(B4,C4)

Combine Text Cells with Excel CONCAT Function

  • Then, press Enter and it’ll return the merged texts.

Combine Text Cells with Excel CONCAT Function

But, if you want space between your merged texts, you have to change a bit in your formula.

STEPS:

  • Firstly, select cell D4 and type the formula:
=CONCAT(B4," ",C4 )

  • Next, press Enter and use the AutoFill tool to get the desired output.


3. Ampersand Symbol in Excel to Unify Text Cells

An easy way to combine text cells in Excel is to use the Ampersand (&) symbol.

STEPS:

  • At first, select cell D4 and type the formula:
=B4&C4

Ampersand Symbol in Excel to Merge Text Cells

  • Next, press Enter, and it’ll return the merged texts in cell D4.

Ampersand Symbol in Excel to Merge Text Cells

But, to place a space between the texts, follow the steps below.

STEPS:

  • First, select cell D4 and type the formula:
=B4&" "&C4

  • Next, press Enter.
  • Use the AutoFill tool to fill the series.


4. TEXTJOIN Function to Unify Text Cells in Excel

Another function to unify text cells in Excel is TEXTJOIN. We’ll use the TEXTJOIN function in this method to merge text cells.

STEPS:

  • First, select cell D4 and type the formula:
=TEXTJOIN(" ",TRUE,B4:C4)

TEXTJOIN Function to Unify Text Cells in Excel

  • Then, press Enter and use the AutoFill tool to get the outcome.


5. Merge Excel Text Cells with Merge Columns Feature

In this method, we’ll use the Merge Columns feature in Excel Power Query Editor to merge Text Cells.

STEPS:

  • First of all, select the range of cells you want to operate on.

Merge Excel Text Cells with Merge Columns Feature

  • Next, select From Table/Range which is in the group Get & Transform Data under the Data tab.

Merge Excel Text Cells with Merge Columns Feature

  • A dialogue box will pop out and uncheck the note My table has headers as our selected range of cells don’t have a header.
  • Then, press OK.

Merge Excel Text Cells with Merge Columns Feature

  • After pressing OK, a new window pop out and select the columns as shown in the image below.

Merge Excel Text Cells with Merge Columns Feature

  • Now, select Merge Columns in From Text group under the Add Column tab.

Merge Excel Text Cells with Merge Columns Feature

  • A dialogue box will pop out.
  • There, select Space from the Separator list.

Merge Excel Text Cells with Merge Columns Feature

  • Now, type Merged in the New column name (optional) and press OK.

Merge Excel Text Cells with Merge Columns Feature

  • Then, it’ll return a new column named Merged with the combined texts.

  • After that, close the Power Query Editor window.
  • A dialogue box will pop out and press Keep.

  • Finally, a new Excel Sheet will get created with the new Merged column.


6. Excel CHAR Function to Join Text Cells with a Line Break

Sometimes we need to merge text cells with a Line Break. In this method, we’ll use the CHAR function to combine texts in Excel with a line break.

STEPS:

  • First of all, select Wrap Text, which you’ll get in the Alignment group under the Home tab.

Excel CHAR Function to Join Text Cells with a Line Break

  • Next, select cell D4 and type the formula:
=TEXTJOIN(CHAR(10),TRUE,B4,C4)

  • Then, press Enter and use the AutoFill tool to fill the series.
  • And finally, you’ll get your required merged texts with a line break.


7. Use ‘Flash Fill’ Feature in Excel to Combine Text Cells

In this method, we’ll apply the Flash Fill feature for merging text cells in Excel.

STEPS:

  • At first, select cell D4 and Type:
Microsoft Outlook

Use ‘Flash Fill’ Feature in Excel to Merge Text Cells

  • In this way, type the second one too.
  • And then, start typing the Third Cell and it’ll suggest you the rest.

Use ‘Flash Fill’ Feature in Excel to Merge Text Cells

  • Finally, press Enter and you’ll get your desired output.


8. Excel Fill Justify Command to Combine Text Cells

The Fill Justify command in Excel can also be used to combine text cells.

STEPS:

  • Firstly, select the range of cells in the column you want to merge.

Excel Fill Justify Command to Combine Text Cells

  • Next, select Justify from Fill drop-down list which you’ll find in the Editing group under the Home tab.

  • And then, it’ll simply merge the texts and return the output in cell B4.


9. Unify Text Cells with Center Across Selection Option

Our last method is to use the Center Across Selection option in Excel to merge text cells. But, this method has a condition: The cell on the right side must be empty.

STEPS:

  • At first, select the range of cells.

Merge Text Cells with Center Across Selection Option

  • Next, press ‘Ctrl’ and ‘+’ keys together and the Format Cells dialogue box will pop out.
  • There, select Center Across Selection from the Horizontal list under the Alignment tab and press OK.

  • In the end, it’ll return the text after merging the two cells.


Conclusion

Now you will be able to Merge Text Cells in Excel with the above-described methods. Keep using them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

Aung

Aung

I'm Aung. Recently I've earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo