To join text in Excel, enter a formula such as =CONCAT(A2," ",B2) in an empty cell, replacing A2 and B2 with the cells you want to combine. CONCAT joins text without adding spaces or punctuation automatically, so include any separators you need between the references. It is useful for combining names, addresses, labels, and other cell contents into one text string.
What You’ll Need
- Excel for Microsoft 365 on Windows, or a version that supports CONCAT, such as Excel 2019 or later. Excel for the web also supports it.
- A workbook with the source text or values in cells, plus an empty cell for the result.
- A decision about what, if anything, should separate the joined pieces: a space, comma, hyphen, or another character.
If you use an older Excel version that does not recognize CONCAT, you can usually join cell references with the ampersand operator (&) or use the older CONCATENATE function. Excel for Mac has CONCAT too; the basic formula steps are the same. Excel for the web uses the same formula syntax, although some ribbon controls and the fill handle may look different.
Step-by-Step
-
Check where your source data is. Identify the cells you want to combine and the order in which they should appear. For example, if A2 contains a first name and B2 contains a last name, the first name should be referenced before the last name. Choose an empty cell for the output so the formula does not overwrite either source value.
-
Select the output cell and start the formula. Click the cell where the combined text should appear. Type an equals sign, followed by CONCAT and an opening parenthesis. You can type the formula directly into the cell or into the formula bar above the worksheet. Excel may show a function suggestion as you type; select CONCAT if it appears.
-
Add the cell references and any separator. With first names in A2 and last names in B2, enter
=CONCAT(A2," ",B2). This formula assumes A2 contains Maya and B2 contains Chen; the displayed result is Maya Chen. The quoted space is a text argument, and it is what puts a visible space between the two names. Without it, the output would be MayaChen. -
Confirm the formula. Press Enter on Windows or Return on Mac. Excel calculates the joined text in the selected cell. If the result does not look right, click the output cell and review the formula bar. Check that each reference points to the intended source cell and that the separators are inside straight double quotation marks.
-
Join more than two cells. CONCAT accepts multiple cell references and text arguments. With a street name in A2, a street type in B2, and an apartment number in C2, enter
=CONCAT(A2," ",B2,", Apt ",C2). If A2 contains 14 Oak, B2 contains Street, and C2 contains 6B, the result is 14 Oak Street, Apt 6B. Add each separator as its own quoted argument where it belongs. -
Combine a range when no separators are needed. If A2 contains the letters N, B2 contains E, and C2 contains W, enter
=CONCAT(A2:C2)in an empty cell to return NEW. A range is convenient when you want to join a continuous block of cells in sequence. CONCAT does not add spaces, commas, or line breaks between the range’s values. -
Apply the formula to other rows. If the source data continues down the sheet, select the cell containing your formula and drag its fill handle—the small square at the lower-right corner—down the output column. Excel adjusts relative references for each row. For example, the formula using A2 and B2 will refer to A3 and B3 on the next row. Double-clicking the fill handle can fill down alongside an adjacent column of data. Review the last few results to ensure the references followed the data correctly.
You can also type CONCAT directly into the formula bar and use the mouse to select cells while building the formula. Separate each argument with a comma in the examples shown here. Some regional settings use semicolons as formula separators; if Excel reports a formula error immediately, check the separator your installation expects. The function name and the quoted text arguments remain the same.
Common Mistakes
Expecting Excel to insert spaces: CONCAT joins exactly the arguments you give it. If you combine a first-name cell and a last-name cell without a space argument, their contents run together. Add a quoted space between the references, or use the appropriate punctuation for the information you are assembling.
Putting punctuation in the wrong place: Text that you want the formula to display must be enclosed in straight double quotation marks. For example, a comma separator needs to be entered as a quoted text argument, not as punctuation typed between two cell references. Commas outside quotation marks separate formula arguments.
Confusing CONCAT with CONCATENATE: Both functions join text, but CONCAT is the newer function and can take a range as an argument. CONCATENATE is retained for compatibility with older workbooks. Neither function automatically inserts a delimiter between items. For a range where you need a chosen delimiter between every value, TEXTJOIN may be more suitable in Excel versions that include it.
Joining numbers or dates and expecting their cell formatting to carry over: A formula combines the underlying value, not necessarily the number format shown in the source cell. A date may appear as a serial number, and a number formatted with leading zeros may lose those zeros in the combined result. Use TEXT to specify the display format when needed, or store identifiers with leading zeros as text.
Assuming a range creates a separate result for every row: A formula such as =CONCAT(A2:C4) produces one combined text result, not a list of separate row-by-row combinations. To combine each row independently, put a formula in the output cell for the first row and fill it down, adjusting the references to that row.
Tips
Plan the final text before writing the formula. Decide whether the result needs spaces around a dash, a comma after a city, or a label such as “Unit” before an apartment number. Treat each separator or fixed label as a text argument, and preview the result on one row before filling the formula through a long list.
Keep the source cells intact when possible. A formula result updates if a referenced cell changes, which is useful for names or addresses that may be corrected later. If you need a fixed copy of the results for an export or handoff, copy the output cells and use Home > Paste > Paste Values. This replaces formulas with their current displayed values, so retain a copy of the original formulas if you might need them again.
Use CONCAT for simple joining, and choose a different tool when the job calls for it. TEXTJOIN can insert a delimiter between multiple values and can be set to ignore empty cells; it is often easier for assembling a list from a range. CONCAT is a good fit when you want to control each piece and separator explicitly. The ampersand operator is another compact option for joining a small number of items.
For dates and numbers, use the TEXT function when the output needs a specific presentation. With a date in A2 and a status in B2, enter =CONCAT(TEXT(A2,"mmm d, yyyy")," - ",B2). If A2 contains November 2, 2026, and B2 contains Confirmed, the result is Nov 2, 2026 – Confirmed. The TEXT format code controls how the date appears in the joined string.
Remember that a formula produces text. The result may look like a number, but it will not behave like a numeric value in calculations until you convert or extract it appropriately. For an identifier, that is usually desirable; for a value you need to add or sort numerically, keep the numeric data in a separate cell.
Troubleshooting
Excel displays #NAME?: Check that the function is spelled CONCAT and that your Excel version supports it. In an older version, use CONCATENATE or join the references with ampersands. If the function name is recognized but the formula still fails, check for missing parentheses or quotation marks.
The formula appears as text instead of calculating: The cell may be formatted as Text, or the formula may have a leading apostrophe. Change the cell format to General using Home > Number Format > General, then edit the cell and press Enter. Changing the format alone may not recalculate a formula already stored as text; re-enter it after changing the format.
The result has no spaces, or has too many: CONCAT does not create separators automatically. Add a quoted space where one is needed. If blank source cells cause doubled spaces, inspect the formula’s separator arguments and consider using TEXTJOIN, which can ignore empty cells. Also check whether a source cell already contains a leading or trailing space.
A date or number looks wrong: The joined string may be showing the stored value rather than the source cell’s display format. Wrap that reference in TEXT and supply a format code, as in the date example above. For leading-zero codes such as postal or product identifiers, consider storing the source as text so the zeros are preserved.
The copied formula points to unexpected cells: Relative references change as you fill a formula down or across. Check the formula in a later row against the matching source row. If one reference must stay fixed while the formula moves, use dollar signs in that reference—for example, $A$1 stays fixed when copied—while leaving row-specific references relative.
Frequently Asked Questions
Is CONCAT available in Excel for Mac and Excel for the web?
Yes. CONCAT is available in supported Microsoft 365 versions on Mac and in Excel for the web. The formula works the same way; the interface for selecting cells or filling formulas may look a little different.
Does CONCAT add a space or comma automatically?
No. It joins the arguments exactly as supplied. Include a quoted space, comma, hyphen, or other separator wherever it should appear in the result.
Can CONCAT join an entire range?
Yes. You can provide a cell range, such as A2:C2, and Excel joins its contents into one text result. It does not insert delimiters, and it does not create a separate result for every row in a multirow range.
What is the difference between CONCAT and TEXTJOIN?
CONCAT joins supplied text and ranges without a built-in delimiter setting. TEXTJOIN lets you choose a delimiter and optionally ignore empty cells, making it useful for joining a list with consistent separators.
Can I use CONCAT to combine numbers and text?
Yes. Excel converts numbers to text in the result, but the source cell’s number formatting may not carry over. Use TEXT inside the formula if a number or date needs a particular display format.
Can I undo a CONCAT formula?
Yes. Use Undo immediately after entering it, or clear the formula cell. If you have already copied the result as values, undo may no longer restore the original formula, so keep a backup or copy of the formula column before replacing it.
Related
- Excel Data Model: What It Is and How to Use It
- Excel Data Model: Can You Turn It Off?
- Excel Data Model and SharePoint: How They Work
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel TEXTJOIN Limit: Character Cap and WorkaroundsIn Excel, TEXTJOIN can return a maximum of 32,767 characters in one cell—the worksheet cell-content limit. If its…
- IFERROR with AVERAGE in Excel: Formulas and ExamplesTo use IFERROR with AVERAGE in Excel, wrap the average calculation in IFERROR: with the values to average…
- DAX Function in Excel: What It Does and How to Use ItDAX in Excel is a formula language for calculations in the workbook Data Model, used through Power Pivot…
- Excel MIN Without Blanks: What the Formula IgnoresIf your values are in A2:A10, use =MIN(A2:A10) to find the smallest number while ignoring blank cells. Excel’s…
- Excel ROUND DOWN to Whole Number: Formulas and ExamplesTo round a number down to a whole number in Excel, use ROUNDDOWN with zero decimal places. If…
- XLOOKUP Spreadsheet Examples for Everyday Excel TasksXLOOKUP finds a value in one range and returns the corresponding value from another range; for example, with…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.