Aung Shine
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.
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.
- Next, select the ‘Merge & Center’ option from the Alignment group under the Home tab.
- 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.
Read More: How to Merge and Center Cells in Excel (3 Easy Methods)
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)
- Then, press Enter and it’ll return the merged texts.
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.
Read More: How to Merge Cells in Excel Vertically Without Losing Data
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
- Next, press Enter, and it’ll return the merged texts in cell D4.
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.
Read More: How to Merge Cells in Excel Table (7 Ways)
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)
- 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.
- Next, select From Table/Range which is in the group Get & Transform Data under the Data tab.
- 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.
- After pressing OK, a new window pop out and select the columns as shown in the image below.
- Now, select Merge Columns in From Text group under the Add Column tab.
- A dialogue box will pop out.
- There, select Space from the Separator list.
- Now, type Merged in the New column name (optional) and press OK.
- 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.
Read More: How to Merge Cells in Excel with Data (3 Ways)
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.
- 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.
Read More: VBA to Merge Cells in Excel (9 Methods)
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
- In this way, type the second one too.
- And then, start typing the Third Cell and it’ll suggest you the rest.
- Finally, press Enter and you’ll get your desired output.
Read More: How to Merge Multiple Cells in Excel at Once (3 Quick Ways)
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.
- 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.
Read More: How to Merge Two Cells in Excel without Losing Any Data
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.
- 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.
Read More: How to Merge Text from Two Cells in Excel (7 Methods)
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.
