How To Combine Text From Two Cells In Excel (2026)

Excel can join the contents of two or more cells into one cell with a formula.

You can use the ampersand symbol, the CONCAT function or the TEXTJOIN function.

This guide shows the formula for each method, how to add spaces and commas, and what to do with numbers and dates.

Quick answer: combine text in Excel

MethodExample formulaBest for
Ampersand (&)=A2&" "&B2Joining two or three cells with a space between them
CONCAT=CONCAT(A2, " Family")Joining cells, ranges and text in one formula
TEXTJOIN=TEXTJOIN(", ", TRUE, A2:A8)Joining a range with a separator and skipping blank cells

Microsoft says these methods work in Excel for Microsoft 365, Excel 2024, Excel 2021 and Excel 2019, and CONCAT also in Excel 2016.

Combine two cells with the ampersand

  1. Select the cell where you want the combined text.
  2. Type = and select the first cell.
  3. Type &, then type a space inside quotation marks: ” “.
  4. Type & again and select the second cell.
  5. Press Enter.

For cells A2 and B2 the finished formula is =A2&" "&B2.

Excel adds a space or any other text only when you put it inside quotation marks.

Combine cells with CONCAT

  1. Select the cell for the result.
  2. Type =CONCAT( and select the first cell.
  3. Type a comma, then add the next cell or a piece of text in quotation marks.
  4. Close the formula with ) and press Enter.

A formula such as =CONCAT(A2, " Family") joins the cell value and the quoted text.

Commas separate the items, and quoted text inside the formula is added to the result.

CONCAT examples

FormulaWhat it does
=CONCAT(B2:C8)Joins every value in the range, row by row
=CONCAT(B:B, C:C)Joins every value in both full columns
=CONCAT(C2, ", ", B2)Reverses a name and adds a comma, such as Hauser, Andreas
=CONCAT("Stream population for ", A2," ", A3, " is ", A4, "/mile.")Builds a sentence from cell values and text

A range inside CONCAT does not add separators, because the function has no delimiter option.

Combine a range with TEXTJOIN

The syntax is TEXTJOIN(delimiter, ignore_empty, text1, [text2], …).

ArgumentWhat it means
delimiterThe text placed between each joined value, in double quotation marks
ignore_emptyTRUE skips empty cells and FALSE includes them
text1The first item to join, either text or a range of cells
text2, …Optional extra items, up to 252 text arguments in total

The formula =TEXTJOIN(", ", TRUE, A2:A8) joins a list in A2:A8 into one string with commas between the values.

If ignore_empty is FALSE, blank cells appear as consecutive delimiters in the result.

With an empty delimiter, TEXTJOIN works like simple concatenation.

Combine first and last names

Suppose first names sit in column A and last names in column B, starting in row 2.

Result you wantFormulaSeparator
Nancy Davolio=A2&" "&B2A space
Fuller, Andrew=B3&", "&A3A comma and a space
Nancy Davolio=CONCAT(A2," ",B2)A space, using CONCAT

Enter the formula in the first result cell and copy it down the column.

To keep only the text and drop the formulas, select the cells, then go to Home > Clipboard > Copy, then Paste > Paste Values.

Combine names with Flash Fill instead

Flash Fill detects a pattern in what you type and fills in the rest, so no formula is needed.

  1. Type the full name in the first empty cell, for example C2, and press Enter.
  2. Start typing the next full name in C3, and Excel shows a preview of the rest of the column.
  3. Press Enter to accept the preview.

If no preview appears, go to Data > Flash Fill or press Ctrl + E to run it manually.

Automatic Flash Fill can be switched on under Options > Advanced > Editing Options > Automatically Flash Fill, though newer versions may label the path differently.

Flash Fill works only when Excel can recognize a pattern from what you type.

CONCATENATE details if you still use it

The syntax is CONCATENATE(text1, [text2], ...), and it accepts up to 255 items with a combined total of 8,192 characters.

The ampersand returns the same result, so =A1&B1 equals =CONCATENATE(A1,B1).

Words run together unless you add a quoted space as its own argument.

A #NAME? error appears when a text argument is missing its quotation marks.

To format a number while joining it, use TEXT, as in =TEXT(A1,"$0.00"), which returns $23.50 when A1 contains 23.5.

Which method should you use?

  • Use the ampersand for quick joins of two or three cells.
  • Use CONCAT when the formula mixes cells, ranges and text.
  • Use TEXTJOIN when you need a separator or want to skip blank cells.

Microsoft says CONCAT does not accept a delimiter or an ignore-empty argument, and it points to TEXTJOIN when you need either.

What happened to CONCATENATE?

Microsoft says CONCAT replaces the older CONCATENATE function.

CONCATENATE remains available for compatibility with earlier versions, but Microsoft says it may be removed in future versions.

For new workbooks, use CONCAT, TEXTJOIN or the ampersand instead.

Combine text with numbers

When you join a number to text, the result is text, so you can no longer use it in math.

Excel uses the cell’s underlying value, not what it displays, so a cell showing 40% holds 0.4.

Use the TEXT function inside the formula to control how the number appears in the result.

If you only want text to appear next to a number without changing it, use a custom number format instead.

Format codeWhat it shows
"Product # " 012 appears as Product #12 and stays a number
h:mm AM/PM "EST"A time followed by the label EST
$0.00 "Surplus";$-0.00 "Shortage"Surplus for zero or positive values, Shortage for negative ones

Microsoft explains that custom number formats change only the display, so sorting and math still work on the stored value.

Limits and errors

FunctionLimit
CONCATUp to 253 text arguments
TEXTJOINUp to 252 text arguments
CONCATENATEUp to 255 items and 8,192 characters in total
CONCAT and TEXTJOINA result longer than 32,767 characters returns the #VALUE! error

To do the opposite and divide one cell into several, see how to split text into columns in Excel.

If joined numbers behave strangely, read how to convert numbers stored as text and how to fix #N/A, #VALUE! and #REF! errors.

Official sources: Combine text from two or more cells, TEXTJOIN function, CONCAT function and Combine text and numbers.

Leave a Reply

Your email address will not be published. Required fields are marked *