CONCAT
TextExcel 2019Join text from ranges or values into one string.
Syntax
CONCAT(text1, [text2], …)
Arguments
- text1
- The first item or range to join.
- text2 …optional
- More items or ranges. Ranges are read left-to-right, top-to-bottom.
How it works
Joins text without any separator. Replaces CONCATENATE and, unlike it, accepts whole ranges.
Examples
=CONCAT("Order ", A2)
→ Order 1042
=CONCAT(A2:A5)
→ abcd — Each cell's text run together.
Good to know
- To put a separator between items, use TEXTJOIN instead.
Related functions
More Text functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.