CONCAT function
Summary
Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
Syntax
CONCAT(text1, [text2],…)
text1 (required) | Text item to be joined. A string, or array of strings, such as a range of cells.
[text2, ...] (optional) | Additional text items to be joined. There can be a maximum of 253 text arguments for the text items. Each can be a string, or array of strings, such as a range of cells.
For example, =CONCAT("The"," ","sun"," ","will"," ","come"," ","up"," ","tomorrow.") will return The sun will come up tomorrow.
Tip: To include delimiters (such as spacing or ampersands (&)) between the text you want to combine, and to remove empty arguments you don't want to appear in the combined text result, you can use the TEXTJOIN function.
[text2, ...] (optional) | Additional text items to be joined. There can be a maximum of 253 text arguments for the text items. Each can be a string, or array of strings, such as a range of cells.
For example, =CONCAT("The"," ","sun"," ","will"," ","come"," ","up"," ","tomorrow.") will return The sun will come up tomorrow.
Tip: To include delimiters (such as spacing or ampersands (&)) between the text you want to combine, and to remove empty arguments you don't want to appear in the combined text result, you can use the TEXTJOIN function.
Example
=CONCAT(B:B, C:C)
=CONCAT(B2:C8)
=CONCAT("Stream population for ", A2," ", A3, " is ", A4, "/mile.")
=CONCAT(B2," ", C2)
=CONCAT(C2, ", ", B2)
=CONCAT(B3," & ", C3)
=B3 & " & " & C3
=CONCAT(B2:C8)
=CONCAT("Stream population for ", A2," ", A3, " is ", A4, "/mile.")
=CONCAT(B2," ", C2)
=CONCAT(C2, ", ", B2)
=CONCAT(B3," & ", C3)
=B3 & " & " & C3