Lesson 25 · Text
Combine Text (& and CONCATENATE)
Join text in Google Sheets with the & operator and CONCATENATE. Build full names, emails and labels.
Combine first and last name with a space between them. Answer in C2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
Joining text together
The quickest way to combine text is the ampersand &:
=A2 & " " & B2
Anything you add yourself, such as a space, comma or domain, goes in double quotes. CONCATENATE does the same thing as a function:
=CONCATENATE(A2, " ", B2)
CONCAT exists too, but in Google Sheets it only accepts two values, so & or CONCATENATE is usually easier.
Combine with other text functions to build values: =LOWER(A2 & "." & B2 & "@acme.co").