Concatenate
Syntax – CONCATENATE( text1, text2, ... text_n ) Concatenate is just a fancy name for “Join”. When you join two or more text strings together, to convert it into one whole text string, it is called concatenation. Any text in Excel will be put inside of double quotation marks, (“Hi George“) for Excel to understand it as Text. Also note, a space character is also a text string, and is wrapped around double quotation marks (“ “). Let’s check out an example - In the picture above