The CONCAT function combines text from multiple ranges and/or strings.
CONCAT replaces the CONCATENATE function. However, the CONCATENATE function will stay available for compatibility.
CONCAT(text1, [text2],…)
-
text1 (required) Text item to be joined. A string, or array of strings, like a range of cells.
-
[text2, ...] (optional) Additional text items to join, up to 253 text arguments.
For example, =CONCAT("The"," ","sun"," ","came"," ","out"," ","today.") returns The sun came out today.
For more info, see CONCAT function.
Tip: Use the ampersand & to concatenate strings. ="Sun's"&" "&"out" displays Sun's out.
The CONCAT function combines text from multiple ranges and/or strings.
CONCAT replaces the CONCATENATE function. However, the CONCATENATE function will stay available for compatibility.
CONCAT(text1, [text2],…)
-
text1 (required) Text item to be joined. A string, or array of strings, like a range of cells.
-
[text2, ...] (optional) Additional text items to join, up to 253 text arguments.
For example, =CONCAT("The"," ","sun"," ","came"," ","out"," ","today.") returns The sun came out today.
For more info, see CONCAT function.
Tip: Use the ampersand & to concatenate strings. ="Sun's"&" "&"out" displays Sun's out.
The CONCAT function combines text from multiple ranges and/or strings.
CONCAT replaces the CONCATENATE function. However, the CONCATENATE function will stay available for compatibility.
CONCAT(text1, [text2],…)
-
text1 (required) Text item to be joined. A string, or array of strings, like a range of cells.
-
[text2, ...] (optional) Additional text items to join, up to 253 text arguments.
For example, =CONCAT("The"," ","sun"," ","came"," ","out"," ","today.") returns The sun came out today.
For more info, see CONCAT function.
Tip: Use the ampersand & to concatenate strings. ="Sun's"&" "&"out" displays Sun's out.
