この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
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")結果: Hello World
Combines three separate strings including a space character.
No, it simply joins the characters exactly as they are provided.