Concatenate Function in Excel
Concatenate in Excel is a function that is used to join multiple texts or strings into single text or string.
It means, using Concatenate function you can join a text from different cells.
And you can also use Concatenate function with space in Excel.
Note:-Before starting any Formula or Function you need to add (=)
Syntax:- CONCATENATE(text1, [text2], ...)
Note:- You can also use "&" operator to Join texts instead of Concatenate function in Excel.
How to Use Concatenate in Excel?
In the below given example, we have two columns with first name and last name. Now using Concatenate function we are going to join both names into single name.
To Join texts in Excel, execute below steps.
1. Select a cell where you want to join texts. (C2)
2. Type CONCATENATE in the formula bar and then select texts you want to Join.
3.=CONCATENATE(A2,B2)
4. You can join multiple texts with seperation of comma.
Result:
Concatenate with Space
In the below given example, I have joined two texts with space. you can also add custom values like the hyphen(-) or symbols or texts in between concatenate function.
Concatenate with Symbol
Here we have added two texts with a hyphen(-) or Dash symbol.
Using & Operator
You can also use an ampersand (" & ") operator to join texts in Excel. it will give the same result.
