Joins two or more text strings into one string.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
CONCATENATE(text1, [text2], …)The CONCATENATE function is used to combine text from multiple cells or static strings into a single cell. While still available for backward compatibility, it is recommended to use the CONCAT or TEXTJOIN functions in newer versions of Excel.
=CONCATENATE("Hello", " ", "World")Result: Hello World
Combines three separate strings including a space character.
No, it simply joins the characters exactly as they are provided.