Arguments
text1- The first text or cell to join.text2(optional) - Additional text or cells.
CONCAT & the & operator
Joins text from several cells or literal strings into one value.
Syntax
=A1 & " " & B1 or =CONCAT(text1, [text2], …)=A2 & " " & B2Returns: First and last name with a space
The & operator is the most portable way to join text.
=CONCAT(A2:A5)Returns: All values in the range run together
CONCAT accepts ranges; use TEXTJOIN when you need a delimiter.
Common Errors and Gotchas
- Literal text and spaces must be quoted: & " " &.
- Numbers joined to text become text - wrap with TEXT() to control formatting.
Does CONCAT & the & operator Work in Google Sheets?
Yes. CONCAT & the & operator uses the same syntax in Google Sheets and LibreOffice Calc, so you can paste these formulas straight across.