Joins two or more text strings into one string.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
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")Kết quả: Hello World
Combines three separate strings including a space character.
No, it simply joins the characters exactly as they are provided.