CONCAT
Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
TextModern Excel FunctionsMost UsedText Processing
What it does
Joins text strings together into one text value.
Syntax
CONCAT(text1, [text2], ...)
Arguments
text1(text|range) — First text item to join.
Examples
Join first and last name
Combine First and Last with a space.
FORMULA
=CONCAT(A2," ",B2)
RESULT
Ana Silva
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | First | Last |
| 2 | Ana | Silva |
| 3 | Tom | Lee |