CONCATENATE Function in Excel

Where text1, text2, can be strings, numbers, cell references, Blank spaces and special characters. We can join multiple cell references to into one string.

Note:1. Up to 255 text entries (arguments) can be added to the “CONCATENATE” function. Each entry must be separated by a comma.
2. If you concatenate a cell that contains numeric value, the result is converted to text.
3. We can do concatenate different strings with using “Ampersand” symbol (&) also

CONCATENATE Function in Excel – Examples

Ex:
=”Analysis”&”tabs” – Analysistabs
=”Analysis”&” “ &”tabs” – Analysis tabs
A1-John, B1 – Rock
=A1& B1 – JohnRock
=A1&” “& B1 – John Rock
=A1&”, “& B1 – John,Rock

Reference:

Please refer the below article for more Text Excel functions.
Text Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home