Excel Concatenate Formula Examples for Text and Cells

With a first name in A2 and a last name in B2, join them with a space using =A2&" "&B2; if A2 contains Grace and B2 contains Hopper, the result is Grace Hopper. In Excel for Microsoft 365, the ampersand operator is the simplest way to concatenate text, while CONCAT and TEXTJOIN are useful alternatives for combining ranges and handling separators or blank cells.

Quick Excel concatenate formula examples

Concatenation means joining text or cell values into one text string. These examples cover common tasks, from combining names to adding a readable label to a number. Each formula assumes the stated cell layout, so you can replace the references with the cells in your own worksheet.

With first name in A2 and last name in B2, =A2&" "&B2 returns Grace Hopper when those cells contain Grace and Hopper.
With a city in A2 and a state abbreviation in B2, =A2&", "&B2 returns Denver, CO when the cells contain Denver and CO.
With a product name in A2 and a code in B2, =A2&" ("&B2&")" returns Notebook (N-14) when A2 contains Notebook and B2 contains N-14.
With the words in A2:C2 containing North, Main, and Street, =CONCAT(A2:C2) returns NorthMainStreet. CONCAT does not add spaces or punctuation for you.
With Seattle in A2, a blank in A3, and Portland in A4, =TEXTJOIN(", ",TRUE,A2:A4) returns Seattle, Portland. The TRUE argument tells Excel to ignore empty cells.

For a basic join, the operator example is usually easiest to read and edit. Use TEXTJOIN when you want the same delimiter between many values or want blank cells skipped automatically.

What concatenation does in Excel

Concatenation combines separate pieces of text into a single result. The pieces can be typed text in a formula, values from cells, or a mixture of both. The result is a text string in a cell; it does not merge the original cells or change their contents. For example, joining a first-name cell and a last-name cell creates a displayed full name in the formula cell while leaving the source names untouched.

That distinction matters when you plan to sort, filter, calculate, or update the data later. A concatenated result is useful for labels, display names, addresses, and identifiers, but it is not necessarily a replacement for the original columns. Keep source values when you may need to edit one component independently or use it in calculations.

Excel does not insert a separator automatically. If two adjacent cells contain Ada and Lovelace, joining the cells without adding a space produces AdaLovelace. Include the desired space, comma, slash, or other punctuation as text in the formula. A separator is part of the result, not a formatting setting.

Use the ampersand operator for simple joins

The ampersand (&) is Excel’s direct concatenation operator. Put it between each value or text fragment you want to join. Text typed directly into a formula must be enclosed in straight double quotation marks, while cell references are written without quotation marks. Add a quoted space between references when you need a gap between the values.

With a first name in A2 and a last name in B2, =A2&" "&B2 returns Grace Hopper when A2 is Grace and B2 is Hopper. This pattern is flexible: you can place a fixed label before a cell, or add punctuation between cells. With order number 1042 in A2, ="Order "&A2 returns Order 1042. The trailing space inside the quoted label separates the word from the number.

References such as A2 are relative. If you copy a formula down one row, Excel normally changes them to A3 and B3. This makes the operator convenient for preparing many rows of labels or names. If you need a reference to stay fixed while copying, use Excel’s standard absolute-reference notation, such as $A$2, for the cell that should not move.

Use CONCAT to join cells or ranges

CONCAT is a function for joining text and cell values. It can take individual references or a range, which can make a formula tidier when you want the contents of several adjacent cells in sequence. It does not provide a delimiter argument, however. If spaces or punctuation are needed, include them as separate arguments or use the ampersand operator.

With first name in A2 and last name in B2, =CONCAT(A2," ",B2) returns Grace Hopper when the cells contain Grace and Hopper. With the three components North, Main, and Street in A2:C2, =CONCAT(A2:C2) returns NorthMainStreet, with no spaces. To control spaces within a range, you can combine selected cell references and quoted separators as arguments.

CONCAT is available in Microsoft 365 and Excel 2019 or later. If a workbook must work in older Excel versions, check the recipient’s version before relying on newer functions. Excel retains the older CONCATENATE function for compatibility, but CONCAT is generally the clearer function name for newer workbooks. For a simple two-cell join, the ampersand operator is also widely compatible.

Use TEXTJOIN for separators and blank cells

TEXTJOIN is designed for joining multiple values with a chosen delimiter. Its arguments are the delimiter, a TRUE or FALSE choice for whether to ignore empty cells, and the text or cell range to combine. This is especially useful for lists, where you want a comma and a space between entries rather than having to place a separator manually between every pair.

With Seattle in A2, an empty A3, and Portland in A4, =TEXTJOIN(", ",TRUE,A2:A4) returns Seattle, Portland. TRUE skips empty cells, so the formula does not add an extra comma for A3. With the same entries and FALSE instead of TRUE, the empty cell is not ignored; the delimiter still separates the positions in the range, which can leave a visible gap between separators.

With department names in A2:A5 and a semicolon as the desired separator, =TEXTJOIN("; ",TRUE,A2:A5) joins the non-empty entries with semicolon-space between them. TEXTJOIN is available in Microsoft 365 and Excel 2019 or later. If the delimiter needs to vary by row, you can refer to a cell containing the delimiter instead of typing it into the formula.

Keep numbers, dates, and labels readable

When a number is concatenated with text, the result is text. Excel may show the number in a basic form rather than using the number format you see in the source cell. If the exact appearance matters, use TEXT to apply a format as part of the formula. This is important for currency, dates, percentages, and numbers with leading zeroes.

With order number 1042 in A2 and numeric amount 1250 in B2, ="Order "&A2&" — "&TEXT(B2,"$#,##0.00") returns Order 1042 — $1,250.00. The TEXT pattern requests a dollar sign, a thousands separator, and two decimal places. The result is a text label, not a numeric amount that can be added directly to other amounts.

With a date in A2 that represents January 5, 2026, ="Due "&TEXT(A2,"mmm d, yyyy") returns Due Jan 5, 2026 in an English-language setting. Without TEXT, concatenating a date can show its underlying serial number or another display that is not suitable for a sentence. Choose a date pattern that fits the audience and workbook locale; month names and separators can display differently under different regional settings.

Handle blanks, spaces, and missing values

Leading or trailing spaces in source cells can make a combined result look inconsistent. A formula that joins a name with a space assumes the source values themselves are clean. If one cell already ends in a space, the result may contain two spaces; if a cell is empty, a fixed separator may still appear. Inspect the source data before treating every odd-looking result as a formula error.

With a first name in A2 and a last name in B2, =IF(A2="","",A2&" "&B2) returns a blank result when A2 is blank; if A2 contains Grace and B2 contains Hopper, it returns Grace Hopper. This check only tests A2. If either name could be missing, decide what output makes sense for your data rather than assuming one blank-handling rule fits every case.

TEXTJOIN’s ignore-empty option can help with lists, but a cell containing a space is not empty, so that space is not skipped. A formula in a cell that returns an empty string can behave like an empty value for this purpose, while a cell containing invisible spaces may still create unexpected gaps. If you need to clean imported text, use a separate cleanup step or an appropriate text-cleaning formula before joining it.

Common concatenate problems and how to fix them

Missing spaces or punctuation: Excel joins only what the formula specifies. Add a quoted separator between the references, then check for spaces already present in the source cells.
Numbers or dates look different: Concatenation creates text and may not preserve the source cell’s display format. Wrap the value in TEXT and choose a suitable number or date pattern.
Formula displays instead of a result: Check whether the cell is formatted as Text or whether Show Formulas is enabled. Set the cell format to General, then re-enter the formula if needed.
An error appears: Check that referenced cells do not contain an error value, and confirm that the formula has balanced parentheses and quotation marks. A concatenation can carry an error from one of its input cells into the result.
Commas are rejected: Some regional settings use semicolons between function arguments instead of commas. The examples here use comma separators; if Excel’s regional configuration expects semicolons, use the separator Excel accepts.
The output is too long: A cell can contain up to 32,767 characters. If a combined result exceeds the worksheet cell limit, reduce the amount being joined or split the output across cells.

When a result looks wrong, evaluate its parts separately: check the source values, the separator, and any formatting conversion. This simple review often reveals whether the issue is an empty cell, an extra space, a display format, or a source error.

Choose the right method for your worksheet

Choose the method based on the shape of the task, not on a claim that one formula is always best. The ampersand operator is straightforward for a few cells and mixed text. CONCAT is convenient for a range when you do not need a repeated separator. TEXTJOIN is usually the most practical option for joining a list with a delimiter and controlling whether blanks are ignored.

If you share a workbook, consider the Excel versions your colleagues use. CONCAT and TEXTJOIN are available in Microsoft 365 and Excel 2019 or later, while the ampersand operator works in older versions too. If the combined text is intended as a permanent export rather than a live result, you may eventually need to copy the results and paste values; otherwise, formulas update when their source cells change.

Frequently Asked Questions

What is the simplest concatenate formula in Excel?

For two cells, use the ampersand operator between them. Add a quoted space or other separator if the combined values need one. For example, the first-name and last-name pattern above creates a readable full name.

What is the difference between CONCAT and TEXTJOIN?

CONCAT joins its arguments but does not insert a delimiter between values. TEXTJOIN lets you specify a delimiter and choose whether empty cells are ignored, making it useful for lists.

How do I combine cells with a comma and a space?

Place a comma and a space in quotation marks between the cell references. For a longer range, TEXTJOIN can apply that same separator between the non-empty entries.

Can Excel concatenate numbers and dates?

Yes. Excel can join them with text, but the output becomes text and may not retain the source number format. Use TEXT when you need a particular currency, decimal, or date appearance.

Why does my concatenated result contain extra spaces?

One or more source cells may contain leading, trailing, or repeated spaces, or the formula may add a separator where a source value is blank. Check the inputs and choose blank handling that matches the worksheet.

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

More in Formulas & functions

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

Spotted an error in this guide? Let us know.