Excel CONCAT and Text: Formulas, Examples, and Fixes

Formulas & functions · Updated November 18, 2026

To join text and cell values in Excel, use CONCAT or the ampersand operator. For example, if A2 contains a first name and B2 a last name, enter =CONCAT(A2," ",B2) to join them with a space; use & for the same result with a shorter formula.

What CONCAT Does in Excel

Concatenation means joining pieces of text into one text string. In Microsoft Excel for Microsoft 365 on Windows, the CONCAT function can join text you type directly, values from cells, or values in a cell range. The pieces appear in the order you list them, and Excel does not add spaces or punctuation automatically.

For example, joining a city in one cell and a state abbreviation in another without adding a separator may produce a result such as SeattleWA. To make the result readable, include the separator as a text argument. Text you type directly into a formula must be enclosed in straight double quotation marks; cell references do not need quotation marks.

With Seattle in A2 and WA in B2, the formula =CONCAT(A2,", ",B2) returns Seattle, WA. If either source cell changes, the result updates automatically, as long as Excel is calculating formulas.

CONCAT, the Ampersand, and TEXTJOIN

There are three useful ways to combine text, and the best choice depends on how many pieces you are joining and whether they need a separator.

  • CONCAT is a clear function for joining a few arguments or a range. It does not insert a delimiter between values.
  • The ampersand (&) is a compact operator that joins values and text. It is convenient when you want to read a formula from left to right or insert a separator at a specific point.
  • TEXTJOIN joins multiple values with a delimiter you specify, such as a comma and a space. It can also skip empty cells, making it especially useful for lists.

For example, if A2 contains a first name and B2 contains a last name, =A2&" "&B2 returns the same result as the CONCAT example above. Neither method is inherently more accurate; use the one that makes the formula easiest to understand and maintain.

If A2:A4 contains three product names, the formula =TEXTJOIN(", ",TRUE,A2:A4) combines them with comma-space separators and skips blank cells. The TRUE argument tells TEXTJOIN to ignore empty cells. Use FALSE if empty cells should still occupy a position between delimiters.

Build a Name, Label, or Sentence

A practical way to create a readable result is to identify each piece first: the cell values, any fixed words, and the punctuation or spacing between them. Then add those pieces in order. Fixed words and punctuation belong inside quotation marks; references point to the cells that hold changing information.

With a title in A2 and a surname in B2, the formula =CONCAT("Hello, ",A2," ",B2,"!") might return Hello, Morgan Lee! The fixed greeting, space, and exclamation mark are all explicit, so the result does not depend on Excel guessing where words should go.

This approach also works for labels and identifiers. Suppose A2 contains the text INV and B2 contains the invoice number 4187. With those values in A2 and B2, the formula =CONCAT(A2,"-",B2) returns INV-4187. If the number has to show leading zeroes, handle its display format deliberately, as described below.

When a formula has many pieces, lay it out with clear separators and check the result against a real example. A missing space or comma is easy to overlook in a long formula. You can also use the Formula Bar to inspect or edit the formula without changing the cell value directly.

Preserve Dates, Numbers, and Leading Zeroes

Concatenation combines underlying values; it does not automatically preserve every cell’s displayed number format. This matters for dates, currency, percentages, and numbers padded with zeroes. A date cell may display as February 3, 2026, while its stored value is a serial number. Joining that value directly can therefore produce an unexpected-looking number.

Use the TEXT function to apply a format as part of the result. If B2 contains the Excel date February 3, 2026, the formula ="Order date: "&TEXT(B2,"mmmm d, yyyy") returns Order date: February 3, 2026. The format code controls the date’s appearance in the joined text; it does not change the value stored in B2.

The same principle applies to currency. If B2 contains the numeric value 1250.5, the formula ="Total: "&TEXT(B2,"$#,##0.00") returns Total: $1,250.50. Choose a format code that fits the data and the audience. In a workbook used across regions, currency symbols and date conventions may need particular attention because they can be interpreted differently.

For an identifier that must always have five digits, use a number format inside TEXT. If A2 contains the number 73, the formula =TEXT(A2,"00000") returns 00073. This creates text for the combined result; it does not turn the source number into a five-digit numeric value. If the original data already contains leading zeroes as text, keep it as text to avoid losing them.

Join a Range With or Without Separators

CONCAT can take a range as an argument, which is useful when you want to join a run of cells without typing each reference separately. If A2:A4 contains Red, Green, and Blue, the formula =CONCAT(A2:A4) returns RedGreenBlue. No spaces, commas, or other delimiters are inserted. For a horizontal or rectangular range, Excel processes the referenced cells in their range order.

That no-delimiter behavior is often the main reason a range result looks wrong. For a comma-separated list, TEXTJOIN is usually more suitable. If A2:A4 contains Red, Green, and Blue, =TEXTJOIN(", ",TRUE,A2:A4) returns Red, Green, Blue. If B2 is blank and the range is A2:A4, the TRUE setting omits the blank rather than adding an empty list item.

TEXTJOIN can also combine non-adjacent cells by listing each reference as an argument. If A2, C2, and E2 contain a person’s first name, middle initial, and last name, the formula =TEXTJOIN(" ",TRUE,A2,C2,E2) joins the nonblank entries with spaces. This can avoid double spaces when one of the optional name fields is empty.

For a single separator between every pair of values, TEXTJOIN is generally easier to maintain than repeating that separator with CONCAT or ampersands. For a custom sentence where different pieces need different punctuation, CONCAT or the ampersand may make the intended structure clearer.

Add a Line Break Inside a Joined Result

A joined result can span multiple lines within one cell. Excel’s CHAR(10) represents a line feed, so it can be inserted between text pieces. Turn on Wrap Text for the result cell to see the lines displayed within the worksheet; otherwise the line break may not be visually apparent.

If A2 contains a person’s name and B2 contains an address, the formula =A2&CHAR(10)&B2 puts the address on the next line in the same cell. Select the result cell, then choose Home > Wrap Text. You may need to adjust the row height to display both lines. The same formula works in current Microsoft 365 Excel for Windows and Mac, although ribbon layout can vary by platform.

Line breaks are useful for compact labels, mailing details, and reports, but they can make sorting, filtering, and exporting less convenient. If the joined text will be analyzed later, keeping separate fields in separate columns is often better than embedding multiple values in one cell.

Common Problems and How to Fix Them

  • Words run together: CONCAT and the ampersand add only the pieces you specify. Add an explicit space, comma, hyphen, or other separator where it belongs.
  • A date becomes a number: Wrap the date reference in TEXT and supply a format such as "mmm d, yyyy" so the joined result has the intended appearance.
  • Leading zeroes disappear: Excel treats ordinary numbers as numeric values, not fixed-width codes. Keep codes as text or use TEXT with a zero format pattern.
  • The result contains an error: A referenced cell may already contain an error, which can flow into the combined result. Check the source cells and correct the underlying error rather than hiding it without understanding it.
  • Excel shows the formula instead of its result: Check whether the cell is formatted as Text, whether the entry begins with an apostrophe, or whether Show Formulas is enabled. Set the cell to General and re-enter the formula if needed.
  • The function name is not recognized: Older Excel versions may not support CONCAT or TEXTJOIN. CONCATENATE is the older function name, while the ampersand operator works as a direct alternative for joining pieces.

Another common misconception is that concatenation merges the source cells. It does not. The formula creates a result in a separate cell and leaves the original values in place. If you need a permanent text result rather than a live formula, copy the result and use Paste Special > Values. Keep a copy of the original columns first if their separate contents may be needed later.

Compatibility and Choosing a Method

CONCAT and TEXTJOIN are available in Microsoft 365 and modern Excel releases, including Excel 2019 and later. In an older workbook environment where one of those function names is unavailable, the ampersand operator is a broadly compatible option. CONCATENATE is also found in older versions, but Microsoft classifies it as a compatibility function and recommends CONCAT for newer workbooks.

Choose based on the shape of the task rather than on a claim that one method is always faster or better:

  • Use the ampersand for a short expression with a few cells and custom text.
  • Use CONCAT when you want a function that joins several specific pieces or a range without separators.
  • Use TEXTJOIN for a range or set of values that needs a consistent delimiter and optional skipping of blank cells.
  • Use TEXT alongside any of these when the displayed form of a number or date matters.

These formulas create text, even when the source cells contain numbers. A combined value such as 20261102 or 00073 may look numeric, but Excel may treat it as text depending on how it was created. That is normally appropriate for labels and identifiers; it may not be suitable for arithmetic. Keep raw numeric values in their own cells when you need calculations, and build a separate text label for display.

Frequently Asked Questions

How do I combine text and a cell in Excel?
Use CONCAT or the ampersand. Put fixed text in double quotation marks and refer to the cell for changing content; add spaces or punctuation explicitly.

How do I add a space between two cells?
Include a space as a text argument between the cell references, or place it between them with the ampersand. Excel will not insert one automatically.

What is the difference between CONCAT and TEXTJOIN?
CONCAT joins pieces without a delimiter. TEXTJOIN lets you specify a delimiter and choose whether empty cells should be ignored.

Can CONCAT join a whole range?
Yes. Reference the range as an argument to join its values in order, but remember that CONCAT does not place separators between them.

Why does my combined date show as a number?
Excel stores dates as numbers. Use TEXT with a date format inside the joined expression when you want a readable date in the result.

Can I turn a formula result into ordinary text?
Yes. Copy the result cell and use Paste Special > Values. This replaces the formula with its current result, so retain the source data if you may need to update it later.

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.