이 함수는 Google Sheets에서도 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.