Microsoft Excel Concatenate Text: Formulas and Examples

Formulas & functions · Updated November 20, 2026

To concatenate text in Microsoft Excel, join cell contents with the ampersand operator (&), or use CONCAT or TEXTJOIN. For example, with a first name in A2 and a last name in B2, =A2&" "&B2 returns a full name with a space between the two parts.

What concatenating text means in Excel

Concatenation means joining two or more pieces of text into one text string. The pieces can come from cells, typed words, numbers, or results returned by other formulas. It is useful for building names, addresses, labels, product codes, sentences, and readable summaries from separate columns.

Concatenation combines values; it does not merge cells or change the source data. If A2 contains “North” and B2 contains “wind,” a formula can display “Northwind” in another cell while A2 and B2 remain separate. The result updates when a referenced cell changes, which is usually safer and easier to maintain than copying and retyping combined values.

In Microsoft 365 for Windows, the three common choices are &, CONCAT, and TEXTJOIN. The ampersand is direct and clear for a few items, CONCAT is convenient for combining cell ranges, and TEXTJOIN adds a delimiter such as a space or comma while optionally skipping empty cells.

Join cells with the ampersand operator

The ampersand (&) is an operator, not a function. Put it between the values to join; use quoted text for any characters you want inserted, such as spaces, commas, or punctuation. In a formula, text constants need straight double quotation marks.

  • With a first name in A2 and a last name in B2, =A2&" "&B2 returns “Maya Chen” if those cells contain Maya and Chen.
  • With a city in A2 and a region in B2, =A2&", "&B2 returns “Dover, Kent” if the cells contain Dover and Kent.
  • With a product code in A2 and a size in B2, =A2&"-"&B2 returns “AX-4” if the cells contain AX and 4.

For each example, enter the formula in a separate output cell, such as C2. You can then fill the formula down for other rows. Excel adjusts relative references automatically, changing A2 and B2 to A3 and B3 in the next row. To keep a reference fixed while filling, add dollar signs, as in $A$2; that is useful when every result must include the same fixed text or value.

Use CONCAT for cells and ranges

CONCAT is the modern function for joining text values. Its syntax is CONCAT(text1, [text2], ...): the first argument is required, and later arguments are optional. It accepts individual cells, typed text, and ranges. Unlike TEXTJOIN, CONCAT does not include a delimiter setting, so add spaces or punctuation as separate arguments when needed.

With a product name in A2, a space in B2, and a model number in C2, =CONCAT(A2,B2,C2) combines the cells as stored. If B2 is blank, the pieces touch; if B2 contains one space, the output includes it. With a three-part name in A2:C2, =CONCAT(A2:C2) joins the range in order without inserting anything between the cells.

CONCAT is available in Microsoft 365 and newer Excel versions; it is not supported by some older releases. If someone opens a workbook in an older version that does not recognize CONCAT, Excel may show a function-name error. For compatibility with old files, the ampersand operator is a simple option, or use the older CONCATENATE function if the target Excel version supports it.

Use TEXTJOIN to add separators

TEXTJOIN is especially useful when joining a list because it takes a delimiter and an option to ignore empty cells. Its syntax is TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...). The delimiter is the text placed between each item; ignore_empty is TRUE or FALSE. This function is available in Microsoft 365 and Excel 2019 or later.

With first, middle, and last names in A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) joins the nonblank cells with spaces. If B2 is empty, the formula returns a normal single-space separation between the remaining names rather than leaving an extra gap. With department names in A2:A5, =TEXTJOIN(", ",TRUE,A2:A5) makes a comma-and-space-separated list and skips blank cells.

Set ignore_empty to FALSE when blank items should still occupy a place in the sequence. This can preserve the positional structure of a list, though adjacent delimiters may appear when an item is blank. Decide deliberately: TRUE is often better for readable names and lists, while FALSE can help when blank positions have meaning.

Choose the right method

All three methods can produce the same basic result, so choose according to the shape of the task and the needs of people who will open the workbook:

  • Use & for a few references and custom text in a short formula. It works in old and current Excel versions and makes each separator visible.
  • Use CONCAT when you want to combine a series or range without a delimiter, or when you prefer a function-style formula.
  • Use TEXTJOIN when the same separator should appear between several items and you need control over blank cells.
  • Use CONCATENATE only when compatibility with an older workbook or process calls for it. Microsoft describes it as a legacy function; & and CONCAT are generally more flexible choices.

For a single full name, the ampersand is often easiest to inspect. For a variable-length list with empty cells, TEXTJOIN is less cumbersome than building a long chain of ampersands. For dozens of cells with no separators, CONCAT can keep the formula compact. None of these options is inherently “more correct”; the best one is the clearest fit for the data and Excel versions involved.

Preserve number, date, and code formatting

A common surprise is that concatenation uses a cell’s underlying value rather than always reproducing its displayed formatting. A date stored as a number may appear as a serial number in the joined result, and a number displayed with currency or leading zeros may lose that visual format. When presentation matters, convert the value to formatted text with TEXT before joining it.

With an order date in A2, =&"Order date: "&TEXT(A2,"mmmm d, yyyy") is not a valid formula; instead use ="Order date: "&TEXT(A2,"mmmm d, yyyy"). If A2 contains the date January 15, 2026, the result is “Order date: January 15, 2026.” The date format code controls the output appearance; the underlying cell remains a date.

With an amount in A2, =TEXT(A2,"$#,##0.00") returns a text representation with a dollar sign and two decimal places. With an identifier in A2 that should display as five digits, =TEXT(A2,"00000") returns leading zeros, such as “00042” for the numeric value 42. Use a format code that matches the intended display, and remember that the result is text, not a numeric value for later arithmetic.

If an identifier is entered as text with its leading zeros already present, concatenating it directly can preserve those characters. For codes, account numbers, and postal codes, storing them as text at the start is often preferable because they are labels, not quantities. Avoid converting them to numbers if their leading zeros carry meaning.

Common problems and how to fix them

  • Missing spaces: Excel does not add spaces automatically. Include a quoted space, such as " ", between references, or use it as the TEXTJOIN delimiter.
  • Unexpected extra spaces: Source cells may contain leading or trailing spaces. If A2 contains a name with stray spaces, =TRIM(A2) removes ordinary extra spaces around and between words. Apply cleanup to the source or incorporate it into a larger formula when needed.
  • Dates or numbers look wrong: Use TEXT with an explicit format pattern before joining, as described above; concatenation does not reliably carry the source cell’s number format into the text result.
  • The formula displays instead of calculating: Check that the cell is not formatted as Text, and confirm the formula begins with an equals sign. If the cell is already Text-formatted, change it to General, then re-enter the formula. Also check whether Show Formulas is enabled on the Formulas tab.
  • Formula error after sharing: Confirm the recipient’s Excel version supports the function. For maximum compatibility, use & instead of a newer function when the task is simple.
  • Unexpected #VALUE! or another error: A referenced cell may already contain an error, which generally flows into the combined result. Check the source cells rather than assuming the joining operator caused it.

In some regional settings, Excel uses semicolons rather than commas between function arguments. The formula language and available function names can also depend on the Excel language installation. If a formula copied from a guide is rejected, check the separator convention in a working formula in that Excel installation; the ampersand operator itself does not need function-argument separators.

Make a line break or a reusable label

To put joined parts on separate lines within one cell, insert a line-break character with CHAR(10), then turn on Wrap Text so the lines are visible. With a street address in A2 and a city and postal code in B2, =A2&CHAR(10)&B2 joins them on separate lines. Select the result cell and choose Home > Wrap Text. On Windows, Alt+Enter inserts a manual line break while editing a cell; on Mac, the shortcut is Control+Option+Return in many Excel configurations. A formula-generated line break uses CHAR(10) regardless of that typing shortcut.

Concatenation can also build a sentence from a value and fixed wording. With a customer name in A2 and an order count in B2, ="Hello, "&A2&". You have "&B2&" open orders." creates a readable message, assuming B2 contains a whole-number count. In a worksheet with many rows, one formula can be filled down to create a row-specific message for each customer.

Keep the formula output separate from the source data until it is checked. If you need a permanent text snapshot rather than a result that changes with its references, copy the output and use Paste Special > Values. The pasted values no longer update when the original cells change, so retain the source columns if the combined string may need to be rebuilt.

Frequently Asked Questions

What is the Excel formula to combine first and last names?
With the first name in A2 and the last name in B2, enter =A2&" "&B2 in another cell. It inserts one space between the names. TEXTJOIN is a convenient alternative if the name has optional middle-name cells that may be blank.

Is CONCATENATE the same as CONCAT?
They serve a similar purpose: joining text. CONCAT is the newer function and accepts ranges, while CONCATENATE is retained for compatibility with older workbooks and does not accept a range in the same way. The ampersand operator is another straightforward alternative.

How do I combine cells and skip blanks?
Use TEXTJOIN with its ignore-empty setting set to TRUE. With entries in A2:A6, =TEXTJOIN(", ",TRUE,A2:A6) joins nonblank entries using comma-space separators. It is available in Microsoft 365 and Excel 2019 or later.

Can I concatenate cells without a space?
Yes. Join the cell references directly, for example =A2&B2, or use CONCAT without a separator. Excel inserts only the characters specified by your formula; it does not automatically add spaces or punctuation.

Can I concatenate text and a date without showing a number?
Yes. Wrap the date reference in TEXT and specify the display pattern, such as =TEXT(A2,"mmm d, yyyy") for a date in A2. This returns formatted text suitable for joining, rather than relying on the date cell’s display format.

Related

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.