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.
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.
In the formula bar, type in the CONCATENATE function “=CONCATENATE(“. The CONCATENATE function takes two or more arguments you want to join together.
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”)“.
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.
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:
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.