CONCATENATE
Joins several text items into one text item.
TextMost UsedText Processing
What it does
Joins text strings together into one text value (legacy; CONCAT is the newer equivalent).
Syntax
CONCATENATE(text1, [text2], ...)
Arguments
text1(text) — First text item to join.
Examples
Join first and last name
Combine First and Last with a space.
FORMULA
=CONCATENATE(A2," ",B2)
RESULT
Ana Silva
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | First | Last |
| 2 | Ana | Silva |
| 3 | Tom | Lee |