Concatenate Text Cells in Excel: Formulas and Tips

Formulas & functions · Updated November 22, 2026

To concatenate text cells in Excel, join their references with the ampersand operator, such as =A2&" "&B2 to combine a first and last name with a space. For a delimiter across several cells, use TEXTJOIN; for a simple join without a delimiter, use CONCAT.

What concatenation means in Excel

Concatenation means combining text from two or more places into one text result. You might use it to build a full name from separate name fields, create a readable address from columns, or attach a label to a number. The original cells remain unchanged: the formula displays a combined result in a separate cell.

For example, suppose A2 contains Maya and B2 contains Chen. A formula can display Maya Chen in C2. The space is part of the formula, not something Excel automatically inserts. Without it, the result would be MayaChen.

Concatenation is different from merging cells. The Merge & Center command combines a cell area for layout and retains only the upper-left cell’s content, potentially removing other entries. A concatenation formula instead preserves the source data and creates a combined result. Use formulas when you need to keep each original value available for editing, sorting, or analysis.

Join cells with the ampersand operator

The ampersand (&) is a direct, flexible way to join cell contents. Enter the formula in the cell where you want the result, then press Enter. Each reference or text fragment is joined in sequence, so you control exactly which spaces or punctuation appear.

  • With the first name in A2 and surname in B2, enter =A2&" "&B2. If the cells contain Maya and Chen, the result is Maya Chen.
  • With a product code in A2 and a size in B2, enter =A2&" - "&B2. If the entries are AX14 and Large, the result is AX14 - Large.
  • To add a fixed label before a cell value, with the city in A2, enter ="City: "&A2. If A2 contains Oslo, Excel displays City: Oslo.

Text that you type directly into a formula must be enclosed in straight double quotation marks. Cell references do not need quotation marks. If you want a literal quotation mark in the result, use two quotation marks inside the quoted text, as in =A2&""""; the result places one quotation mark after the value in A2.

To combine more than two cells, continue adding ampersands and separators. With values in A2, B2, and C2, =A2&" "&B2&" "&C2 places one space between each value. This approach is easy to inspect, although a long expression can become difficult to maintain.

Use CONCAT for a straightforward join

CONCAT combines text from multiple cells or ranges, but it does not add a separator automatically. With a first name in A2 and surname in B2, enter =CONCAT(A2," ",B2). If A2 is Maya and B2 is Chen, the result is Maya Chen. The space is supplied as a separate argument.

For a range, with words in A2 through A4, enter =CONCAT(A2:A4). If the cells contain red, blue, and green, the result is redbluegreen. To add punctuation or spaces between items, include those as arguments or choose TEXTJOIN, which is designed to apply a delimiter across a range.

CONCAT is available in Microsoft 365 and newer Excel versions; older workbooks may use CONCATENATE, a legacy function that remains for compatibility. For a simple two-cell formula, the ampersand is often the clearest option. If you use a function, prefer CONCAT in current Excel rather than starting a new formula with the older function name.

Use TEXTJOIN to add a delimiter

TEXTJOIN combines values using a separator, also called a delimiter, that you choose. It is especially useful for lists because you specify the separator once instead of inserting it between every cell reference. The function is available in Microsoft 365 and Excel 2019 or later.

With city names in A2:A4, enter =TEXTJOIN(", ",TRUE,A2:A4). If the cells contain Rome, an empty cell, and Lima, the result is Rome, Lima. The first argument supplies comma-and-space punctuation. The second argument, TRUE, tells Excel to ignore empty cells; the last argument is the range to join.

Set the second argument to FALSE if you want empty cells to count when Excel places delimiters. For example, with A2 containing North, B2 empty, and C2 containing West, =TEXTJOIN(" / ",FALSE,A2:C2) returns North / / West. With TRUE, the same range returns North / West.

TEXTJOIN works with a single range or multiple text arguments. With the department in A2 and the employee name in B2, =TEXTJOIN(" — ",TRUE,A2,B2) places a dash between the two values while ignoring either value if its cell is empty. Choose a delimiter that makes sense for the intended output: a comma and space for a readable list, a line break for labels, or no separator when values should touch.

Keep dates and numbers readable

When Excel joins a date or number with text, the result may not preserve the way the source cell is displayed. A date stored as a serial number, for example, can appear as a number rather than as a calendar date. Cell formatting controls how a value looks in its own cell, but concatenation creates a text result, so apply the desired display format inside the formula with TEXT.

With the label in A2 and a real Excel date in B2, enter =A2&" "&TEXT(B2,"mmm d, yyyy"). If A2 contains Due and B2 is January 15, 2026, the result is Due Jan 15, 2026. The format code inside TEXT determines the date style; mmm gives an abbreviated month name, while yyyy gives a four-digit year.

With an order number in A2, enter ="Order "&TEXT(A2,"00000"). If A2 contains 42, the result is Order 00042. The zero placeholders preserve leading zeros in the displayed text. For currency or decimal output, choose a format code appropriate to the data and your locale; number-format punctuation can vary with regional settings.

Once a formula has been converted to text, the combined result is not a numeric value suitable for ordinary arithmetic. Keep the source number in its original cell and use a separate numeric formula for calculations. Concatenated output is best treated as presentation text or an identifier.

Handle blanks, spaces, and line breaks

Extra spaces are a common source of messy results. A formula that always inserts a space can leave a leading or trailing space when one of its cells is empty. TEXTJOIN with its ignore-empty option handles empty cells in a range cleanly, but a cell containing spaces is not truly empty and will still be included.

If source values may contain accidental spaces at their edges, clean them with TRIM. With the first and last names in A2 and B2, enter =TRIM(A2)&" "&TRIM(B2). TRIM removes leading and trailing spaces and reduces repeated spaces between words to one. It does not remove every special whitespace character copied from websites, so unusual imported data may need additional cleanup.

To put joined values on separate lines, use the line-break character. With a street address in A2 and a city in B2, enter =A2&CHAR(10)&B2. The result contains a line break between the entries. Select the result cell and choose Home > Wrap Text so Excel displays both lines within the cell; adjust row height if needed. The line break is part of the cell’s text, not a new worksheet row.

Copy the formula and choose the right method

After entering a formula, use the fill handle—the small square at the lower-right corner of the selected cell—to copy it down a column. Relative references adjust automatically: a formula using A2 and B2 becomes a formula using A3 and B3 on the next row. Double-clicking the fill handle often fills down alongside a neighboring column of data. Check the last few results, especially if the adjacent data column has gaps.

Choose a method based on how much control the result needs:

  • Use & for a short, explicit join with custom text or punctuation.
  • Use CONCAT to combine several references or a range when no automatic delimiter is needed.
  • Use TEXTJOIN for a range with a consistent separator and optional skipping of empty cells.
  • Use TEXT inside any of these approaches when a date, number, or time needs a deliberate display format.

If a result must no longer change when source cells change, copy the formula results and use Home > Paste > Paste Values. This replaces formulas with their current displayed values. Keep a copy of the source data first if you may need to revise the output later. To separate previously combined values back into columns, use Data > Text to Columns when the separator is consistent; that is a different operation from concatenating.

Common problems and how to fix them

A missing space or comma is usually not a calculation error: Excel adds only the separators included in the formula. Put a quoted separator between references, such as =A2&", "&B2. If Excel shows the formula itself instead of the result, check that the cell is not formatted as Text, remove any leading apostrophe, and enter the formula again. Also check whether Show Formulas is turned on; press Ctrl+` on Windows to toggle that worksheet view.

If Excel reports a formula problem, verify that each opening parenthesis has a closing parenthesis and that text is enclosed in straight quotation marks. The formulas here use commas between function arguments, which is the standard setup for many installations. Some regional settings require semicolons instead; use the list separator configured for your Excel installation if a copied function formula is rejected.

Another misconception is that concatenating values preserves their original data types. It does not: a formula that joins values returns text. That matters for sorting, matching, and calculations. For instance, a combined value that looks like a date is not necessarily a real Excel date. Keep raw fields in separate columns when later analysis depends on their numeric or date values, and create a separate display column for the combined text.

Finally, avoid confusing a blank cell with a cell that contains a formula returning an empty string. Both may look empty, but formulas and functions can treat them differently in some contexts. If the output has unexpected separators, inspect the source cells and use TEXTJOIN with ignore-empty set to TRUE where appropriate.

Frequently Asked Questions

How do I concatenate cells in Excel with a space?
With text in A2 and B2, enter =A2&" "&B2. The quoted space is the separator. For several cells with blanks to skip, use TEXTJOIN with a space delimiter and its ignore-empty argument set to TRUE.

What is the difference between CONCAT and TEXTJOIN?
CONCAT joins supplied text or ranges without adding a delimiter. TEXTJOIN adds a delimiter you choose and can ignore empty cells. Use the latter for comma-separated lists or other repeated separators.

Can I concatenate an entire column?
Yes, but joining a whole column can produce an extremely long result and may include a large number of blank cells. It is usually clearer to use the actual data range, such as A2:A100, and choose a delimiter that makes the result readable.

Can I combine text and a date without getting a number?
Yes. Use TEXT to specify the date’s display format inside the join, such as =A2&" "&TEXT(B2,"mmm d, yyyy"). Make sure B2 contains a real Excel date, not text that only resembles one.

How do I make the combined result permanent?
Copy the formula cells, then choose Home > Paste > Paste Values. The resulting text will no longer update when the original cells change. Retain the original columns if you need to edit or recompute the combined values 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.