Using the CONCATENATE Function in Excel to Combine Strings

The CONCATENATE function allows you to join several text strings into one text string in Excel. This blog post will show you how to use the CONCATENATE in Excel.

Step 1: Open the formula bar

The first step is to open the formula bar by hitting the tab in Excel. The formula bar is where we will input the CONCATENATE function.

Step 2: Use the CONCATENATE function

In the formula bar, type in the CONCATENATE function “=CONCATENATE(“. The CONCATENATE function takes two or more arguments you want to join together.

Step 3: Add cell numbers or text data

You can add the cell numbers where the text strings are located or manually add your text data within the parentheses of the CONCATENATE function. For example, “=CONCATENATE(B2, C2)” or “=CONCATENATE(“Hello”, ” World”)“.

Step 4: Add spaces

If you want to add spaces between the text strings, you can add a space in between quotes within the function. For example, “=CONCATENATE(B2, “ ”, C2)“. This will add a space between the cell’s text strings when they are concatenated.

Step 5: Joining Multiple Text Strings with CONCATENATE function

You can concatenate or join multiple functions with the CONCATENATE function. Just add the cell numbers of the text strings with a comma inside the parentheses. As shown above, you can add space by adding “ ” between the strings. Here is an example:

Step 6: Apply the CONCATENATE function

Once you have inputted all the necessary information into the CONCATENATE function, you can apply the function by clicking ENTER. The text strings will be concatenated and joined together in the designated cell.


That’s how you can use the CONCATENATE function. As you can see, it’s a simple yet powerful tool to join and concatenate text strings in Excel. Give it a try and see how easy it is to use.