Excel CONCAT Formula Not Working? Common Fixes and Checks

With a first name in A2 and a surname in B2, enter =CONCAT(A2," ",B2) to join them with a space. If the formula is not working, check that your Excel version supports CONCAT, the cell is not formatted as text, and the formula uses the correct separators and references.

What the CONCAT function does

CONCAT combines text from cells, ranges, or typed text into one result. It does not automatically add spaces, commas, or other separators, and it does not perform arithmetic. For example, joining A2 and B2 directly can produce MayaChen rather than Maya Chen. That is often mistaken for a malfunction when the formula has actually worked as written.

With A2 containing Maya and B2 containing Chen, the formula =CONCAT(A2,B2) returns MayaChen. To include a space, with the same cell layout, use =CONCAT(A2," ",B2), which returns Maya Chen. The quoted space is a text argument placed between the two cell references.

CONCAT can also take a range. With A2 containing Maya, B2 containing a space, and C2 containing Chen, enter =CONCAT(A2:C2) to return Maya Chen. A range is convenient when every character or word is already in adjacent cells, but CONCAT will not insert a separator that is absent from the range.

Check the formula syntax and separators

A working Excel formula normally begins with an equals sign. Check for a missing equals sign, a misspelled function name, an unmatched parenthesis, or quotation marks that were copied as typographic curly quotes. Excel formulas need ordinary straight double quotes around text, as in the space argument above. Replacing pasted quotation marks by typing them directly in the formula bar can fix a formula that looks right but is rejected.

Excel normally uses commas between function arguments in the examples here. Some regional settings use semicolons instead, based on the system’s list-separator setting. If Excel displays a message that the formula has a problem when you enter a comma-separated formula, your installation may expect semicolons. Use the separator Excel accepts for your locale; the examples in this article show the standard comma syntax.

Make sure the cell references point to the intended cells. A formula copied down a column adjusts relative references, so a reference to A2 becomes A3 in the next row. If a formula must always refer to a particular cell, use an absolute reference with dollar signs. With a name in A2 and a fixed suffix in D1, for example, =CONCAT(A2,$D$1) keeps D1 fixed when copied down. The result depends on the actual contents of those cells.

When Excel displays the formula instead of its result

If a cell shows something like =CONCAT(A2," ",B2) as text, rather than showing the joined name, Excel may be treating the entry as text. Select the cell and look at its number format on the Home tab. If it is set to Text, change it to General, then edit and re-enter the formula; changing the format alone may not convert an existing text entry into a formula.

A leading apostrophe can also force an entry to be treated as text. Check the formula bar for an apostrophe before the equals sign. Remove it, then confirm the formula again. Another possibility is that Show Formulas is turned on, which displays formulas across the worksheet instead of their calculated results. On Windows, press Ctrl+` to toggle it; on Mac, use Control+` if that shortcut is available on the keyboard, or select Formulas > Show Formulas. The accent key location varies by keyboard layout.

Also distinguish between a formula displayed in a cell and a result that merely looks unchanged. If the joined text happens to be the same as one of the inputs, inspect the formula bar and the referenced cells before assuming Excel did not calculate it.

Why spaces, punctuation, or blanks seem to disappear

CONCAT does not add punctuation automatically. If the output should contain a comma and a space, include those as text arguments. With a city in A2 and a state code in B2, =CONCAT(A2,", ",B2) puts a comma and space between them. If the result has no gap, check that the separator appears inside quotes and between the references, rather than after the closing parenthesis.

Blank cells can make a formula appear incomplete, but CONCAT generally joins the available text without inserting a visible marker for an empty cell. With A2 containing North, B2 blank, and C2 containing Office, =CONCAT(A2:C2) returns NorthOffice. Add a separator explicitly when that is the desired layout. With the same cell contents, =CONCAT(A2," ",B2," ",C2) returns North Office, including two spaces because the formula includes a space on each side of the blank cell. That illustrates why a formula with fixed separators can leave extra spaces when some inputs are empty.

For a list where empty cells should be skipped and each nonblank entry should be separated consistently, TEXTJOIN is often a better fit. With names in A2:A5, =TEXTJOIN(", ",TRUE,A2:A5) joins them with comma-space separators and ignores blank cells because the second argument is TRUE. If the second argument is FALSE, empty cells are included as empty positions, which can leave repeated separators.

Numbers, dates, and formatting in joined text

When CONCAT joins a number or date, it uses the underlying value in a way that may not match the display format you see in the original cell. A date displayed as May 6, 2026, for example, may appear as a serial number in joined text. This is not usually a calculation error; the value needs an explicit text format inside the formula.

With a project label in A2 and a real Excel date in B2, use =CONCAT(A2," — ",TEXT(B2,"mmm d, yyyy")) to show a label followed by a formatted date. If A2 contains Launch and B2 contains May 6, 2026, the result is Launch — May 6, 2026. The TEXT function applies the requested display pattern to the date before CONCAT joins it. Choose a format appropriate to the audience, especially where day and month order could be ambiguous.

For a numeric value that needs a currency symbol or a fixed number of decimal places, use TEXT in the same way. With an item name in A2 and a numeric amount in B2, =CONCAT(A2," — $",TEXT(B2,"0.00")) returns, for example, Notebook — $12.50 when B2 contains 12.5. This only formats the displayed text; it does not change the underlying value or provide accounting or financial advice.

Common errors and version compatibility

A #NAME? error often means Excel does not recognize the function name. CONCAT is available in Microsoft 365 and newer Excel releases, including Excel 2019, Excel 2021, and Excel 2024. If a workbook is being opened in an older Excel release that lacks CONCAT, use the older CONCATENATE function or the ampersand operator instead. A recipient using an older release may see an unsupported-function error even if the formula works on your computer.

A #VALUE! error can occur if the combined result exceeds Excel’s 32,767-character cell limit. It can also be passed through from a referenced cell that already contains an error. Check the inputs individually and, for long text, consider whether the result should be split across cells or whether the source data contains unexpected material.

If a result is technically correct but has unwanted spaces, line breaks, or other characters, inspect the source cells. Data copied from websites or other systems may contain leading or trailing spaces or nonprinting characters. CONCAT preserves ordinary text content; it does not automatically clean or normalize it. A formula that joins the values successfully can therefore expose inconsistencies that were already present in the inputs.

CONCAT, CONCATENATE, TEXTJOIN, and the ampersand

These options overlap, but they suit different situations:

CONCAT is the modern function for joining text and ranges. It is useful when you do not need a separator between every item, or when you want to add separators as explicit arguments.
CONCATENATE is the older function name retained for compatibility. It can join individual items, but CONCAT is the newer choice for current Excel versions and can accept ranges.
TEXTJOIN adds a chosen delimiter between items and can optionally ignore empty cells. It is often clearer for lists, addresses, or values separated by commas.
The ampersand operator joins values without a function. With a first name in A2 and a surname in B2, =A2&" "&B2 returns Maya Chen when those are the cell values. It is concise for a few pieces of text.

For a short formula with two or three components, CONCAT or ampersands are easy to read. For a variable-length list with a consistent delimiter and possible blanks, TEXTJOIN is usually more practical. The choice will not fix incorrect source data or a cell formatted as text, so diagnose those separately.

A quick troubleshooting sequence

Use this order to locate the cause without rebuilding the workbook:

Confirm that the formula begins with an equals sign and that CONCAT is spelled correctly.
Check whether Excel accepts commas or expects another argument separator in your regional settings.
Verify each referenced cell and confirm the formula includes any required space or punctuation as quoted text.
If the formula itself appears in the cell, turn off Show Formulas and check for Text formatting or a leading apostrophe. Re-enter the formula after changing the format.
If Excel returns an error, note the exact error. For #NAME?, check function availability; for #VALUE!, inspect source errors and the output length.
Test a simple formula in an empty cell, then add the original references back one at a time. This helps separate a syntax issue from a problem in the data.

When working in Excel for the web, the same core CONCAT syntax applies. Ribbon placement and keyboard shortcuts can differ from desktop Excel, so use the formula bar and the displayed ribbon commands if a desktop shortcut is unavailable. On Mac, the function itself works the same way; regional separators and some keyboard shortcuts may differ from Windows.

Frequently Asked Questions

Why does CONCAT show the formula instead of the text?
Check whether the cell is formatted as Text, has a leading apostrophe, or whether Show Formulas is enabled. Change the format to General if needed and re-enter the formula; turning off Show Formulas restores normal result display.

Does CONCAT automatically add spaces between names?
No. Add a space as a quoted text argument between the cell references, or use TEXTJOIN when a delimiter should separate a list of values. Without an explicit separator, adjacent text is joined directly.

Why is my date showing as a number in CONCAT?
Excel stores dates as numeric serial values. Format the date as text inside the formula with TEXT, specifying the date pattern you want, before joining it to other text.

What can I use if CONCAT is not available?
Try CONCATENATE in an older Excel version, or use the ampersand operator. If you need separators and blank-cell handling, check whether TEXTJOIN is supported in the version you are using.

Can CONCAT join a whole range?
Yes. A range reference can be supplied to CONCAT, but the function does not insert a delimiter between cells. Include separator cells in the range or use TEXTJOIN when you need a chosen delimiter.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.