Text
Modern
CONCAT
Joins text from multiple cells or ranges into one string, with no delimiter.
Available in Microsoft 365 · Excel 2024 · Excel 2021 · Excel 2019 · Excel 2016 · Excel for the web.
Syntax
CONCAT(text1, [text2])What it returns
A single combined text string.
Arguments
| Argument | Required | Description |
|---|---|---|
text1 |
Yes | The first text item or range to join. |
text2 |
No | Additional text items or ranges to join. |
Example
Invoice-+2024
Result
Invoice-2024
CONCAT joins items end to end, with no separator added.
=CONCAT(A2, B2, C2)Important to know
Adds no separator — use TEXTJOIN if you need one.
Replaces the older CONCATENATE.