How to add two text cells together in excel

Sometimes, we collect data in a different cell and need to combine them in a single cell. What do you think is it much difficult to perform in Excel? Not really. Today I will show you how to combine different cells into a single one. Let’s start with how to add two text cells together in excel.

Identify the problem

The above table shows a small database of 5 names. Column B is the First Name, and Column C is Last Name. We want the Full name in Column D automatically. I will share 4 possible ways to combine cells in Excel.

Solution One: Using the Ampersand (&) symbol

• Select the cell where you want to combine both texts.
• Type = and select the first cell.
• Type & and quotation mark (“_”) with a space enclosed.
• Type & and Select another cell you want to combine with.
• Press Enter to complete.

Read More: How to add second line in Excel.

Solution Two: Using the CONCAT function

• Select the cell where you want to combine both texts.
• Type = CONCAT(, select the first cell and a comma
• Type quotation mark (“_”) with a space enclosed and a comma.
• Select another cell you want to combine with and close the bracket.
• Press Enter.

Solution Three: Using the CONCATENATE function

• Select the cell where you want to combine both texts.
• Type = CONCATENATE(, select the first cell and a comma
• Type quotation mark (“_”) with a space enclosed and a comma.
• Select another cell you want to combine with and close the bracket.
• Press Enter.

Solution Four: Using the TEXTJOIN function

This formula is a little bit advanced level formula. When you combine two or more cells, if any of them are empty cells, the Ampersand (&) function will carry a double space between two cells. The same problem will occur for the CONCAT function. TEXTJOIN formula will give you relief from this issue.

• Select the cell where you want to combine texts.
• Type = TEXTJOIN(” “, select the first cell and a comma
• Select the second cell and a comma.
• Select another cell you want to combine with and close the bracket.
• Press Enter.

Explanation of Syntax

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

delimiter (required) = the double quotation, the character between double quotation is visible between two cells. It can be empty or comma, or any other character. if you type a number as a delimiter, it will be treated as text.

ignore_empty (required) = TRUE/FALSE. if TRUE, it will ignore empty cells.

text1 (required) = Text item to be joined.

text2 (required) = Additional text items to be joined. A maximum of 252 text arguments for the text items, including text1.

Dear learners, I hope you understand the topic “How to add two text cells together in excel.” If you have any queries, please keep a comment in the comment box. I will try to answer your question to the best of my knowledge.