All functions / Text
CONCAT
Joins text from several values or ranges.
Syntax
=CONCAT(text1, [text2], …)
Arguments
text: Text, cells or ranges to join.
Example
=CONCAT(A2, " ", B2) → First and last name
All functions / Text
Joins text from several values or ranges.
=CONCAT(text1, [text2], …)
text: Text, cells or ranges to join.=CONCAT(A2, " ", B2) → First and last name