Knowledge base / Excel
Excel CONCAT: ranges, order and separators
I explain how Excel combines a range, why CONCAT adds no automatic delimiter and when TEXTJOIN fits the intended output.

CONCAT joins text and ranges into one string. I find it useful when combining a small, well-defined range without automatic separators. If I need commas between items and omission of empty cells, I choose a different function.
That distinction matters from the first argument. The Microsoft documentation specifies CONCAT(text1, [text2], ...). There are no delimiter or ignore-empty arguments here. Those belong to TEXTJOIN.
A first formula with synthetic data
Enter these values in the second worksheet row. They form an illustrative product label.
| Cell | Value |
|---|---|
| A2 | Coffee |
| B2 | Ground |
| C2 | Large |
=CONCAT(A2:C2)
The result is CoffeeGroundLarge. The cell contents are appended without spaces. CONCAT does not interpret words or infer product-name boundaries. That might be intended for a code, while a readable label usually needs extra characters.
CONCAT accepts an entire range as an argument. This is one difference from the older CONCATENATE. For a small range, the formula stays short and clearly identifies the included cells.
Supply spaces explicitly
=CONCAT(A2," ",B2," ",C2)
The result is now Coffee Ground Large. Each space is a separate argument. Use the text ", " instead if you need a comma followed by a space. The function appends exactly the pieces you supply.
A comma outside quotation marks separates arguments in the English configuration shown here. A comma inside quotation marks becomes an output character. These roles differ. If your regional settings use another argument separator, adapt the formula to your environment.
For a few cells, =A2&" "&B2&" "&C2 gives the same effect. I do not select a function merely because its name is newer. A short formula should be understandable to the person who will maintain the workbook.
How a rectangular range is read
Consider a separate example: A2 contains A, B2 contains B, A3 contains C and B3 contains D. The formula =CONCAT(A2:B3) returns ABCD: across the first row, then across the next row.
That differs from supplying two column ranges separately. The formula =CONCAT(A2:A3,B2:B3) returns ACBD. The first argument is processed before the second. Microsoft’s CONCAT range examples illustrate the same distinction.
When order matters, use a small controlled range and predict the output character by character. A wide table will not necessarily be read in the order you happen to imagine while looking at the worksheet. Make the sequence part of the formula’s intended behavior.
Empty cells and automatic delimiters
Clear B2 in the product example. CONCAT of the range inserts no content for that empty cell, producing CoffeeLarge. The version with two explicit spaces keeps both spaces. An absent value does not remove other formula arguments.
To get Coffee Large when the middle cell is empty, use:
=TEXTJOIN(" ",TRUE,A2:C2)
TEXTJOIN has a separate delimiter and an option to ignore empty cells. CONCAT does not offer either argument. Adding TRUE to CONCAT does not enable another operating mode.
Check whether a cell is genuinely empty. A typed space is text and can introduce unwanted spacing. Concatenation does not replace cleaning. I first establish which values the source permits, then choose how to assemble a label.

Excel availability and result length
Microsoft specifies Office 2019 or a Microsoft 365 subscription for CONCAT availability on Windows and Mac. Do not establish compatibility solely from a general Excel 2016 label in workbook documentation. Check the recipient’s edition and updates.
The older CONCATENATE remains available for compatibility. It can be sufficient when joining a few explicit arguments in an older workbook. The actual workbook requirements matter more than the introduction date of a function.
Microsoft documents a value error when CONCAT’s result exceeds the cell limit of 32767 characters. I therefore avoid combining whole columns without a reason. A heading, a new row added later or an accidental note can otherwise become part of the same output.
Give numbers and dates an explicit presentation
Concatenation does not automatically preserve a cell’s number format. Dates, percentages and fixed-width numeric displays may need explicit formatting. Microsoft explains the role of TEXT in its guide to combining text and numbers.
I keep the original number in a separate column. A label presents information to a reader, while the source value supports calculations. Adding a description should not make it harder to inspect totals or sort using the appropriate data type.
I also watch for ambiguous codes. Joining AB with C produces the same result as joining A with BC. A generated key therefore needs an unambiguous scheme, such as fixed-width components or safe separators. CONCAT alone cannot guarantee uniqueness.
Exercise: choose by the intended output
Join the three label components without spaces and then with spaces. Clear the middle component and predict both results. Compare them with TEXTJOIN while ignoring empty cells.
Finally reproduce the letter example with a rectangular range and compare it with two separate column ranges. If you can account for every character’s position, you understand the joining order. Continue through the Excel knowledge section for related functions.
Key takeaways
Does CONCAT automatically insert a delimiter?
No. Supply spaces and punctuation as text. TEXTJOIN provides a separate delimiter argument.
Can CONCAT combine a whole range?
Yes. It accepts ranges and reads a rectangular range by rows. Two separately supplied column ranges can produce a different order.
When should I use TEXTJOIN instead?
Use it when you need delimiters between values and an option to ignore empty cells. CONCAT has neither argument.
AI was used in an automated way while working on this article. If you want to learn how to do it too, check out this project.
