CONCATENATE Function in Excel | Microsoft Office Support
The Excel function “Concatenate” is used to combine the values from two or multiple text/cells in to one. The concatenate() function in excel is used to combine the text from different cells. This is useful to join two or more strings into one string.
How to use concatenate function in excel?
Syntax:
=CONCATENATE(text1, text2, text3, text4, text5, …)
Let’s get start with some example:
#Example 1:
=Concatenate(“My name”, “Is janki salvi”, “rashmikantbhai”)
And, the result is "My name Is janki salvi rashmikantbhai".
You may find and learn more Excel Formulas here: