Concat Excel Multiple Cells: Formulas, Spaces, and Tips

Formulas & functions · Updated November 18, 2026

To concat (combine) multiple cells in Excel, use =CONCAT(A2:C2) to join the values in A2 through C2 without a separator, or use =TEXTJOIN(" ",TRUE,A2:C2) to put a space between nonblank values. For a small number of cells, the ampersand operator, such as =A2&" "&B2, is another simple option.

What Concatenating Cells Means

Concatenating means joining text or values from separate cells into one text result. It does not combine the cells themselves, move their contents, or change the original data. If A2 contains Ava and B2 contains Chen, a formula in C2 can display Ava Chen while A2 and B2 remain unchanged.

This is useful for building full names, addresses, product labels, file paths, or descriptions from separate columns. It can also create a single value for exporting or reporting. The result is a formula output, so it updates when a referenced cell changes. If you need a permanent text value rather than a formula, you can copy the results and use Paste Special > Values.

In Excel for Microsoft 365 on Windows, the main choices are CONCAT, TEXTJOIN, and the ampersand operator. The formulas work in Excel for Mac and Excel for the web as well, though some ribbon and keyboard details differ. Choose based on whether you need a separator, how many cells you are combining, and what you want blank cells to do.

Use CONCAT to Join Cells Directly

CONCAT is the modern function for joining text from multiple cells or ranges. It does not add spaces, commas, or other punctuation automatically. If the cells contain Ava, Chen, and Sales in A2:C2, the formula below returns AvaChenSales.

With the values to combine in A2:C2, enter this formula in D2: =CONCAT(A2:C2).

To add a separator with CONCAT, include the separator as a text argument between the cell references. With a first name in A2 and a last name in B2, this version returns Ava Chen if those cells contain Ava and Chen: =CONCAT(A2," ",B2). CONCAT can also combine nonadjacent cells by listing them individually, such as =CONCAT(A2," - ",C2).

CONCAT is convenient when you are joining a range or several values and do not need Excel to manage separators between every item. It is available in modern Excel, including Microsoft 365. In older Excel editions that do not recognize CONCAT, use the ampersand operator or the older CONCATENATE function instead.

Use TEXTJOIN When You Need a Delimiter

TEXTJOIN is often the easiest choice when every value needs the same delimiter, such as a space, comma, slash, or line break. Its arguments specify the delimiter, whether to ignore empty cells, and the cells or ranges to combine. This avoids inserting a separate separator argument between every cell.

With a first name in A2, a middle name in B2, and a last name in C2, enter this formula in D2 to join nonblank names with spaces: =TEXTJOIN(" ",TRUE,A2:C2). If B2 is empty, the result is still Ava Chen rather than Ava followed by two spaces and Chen.

To make a comma-separated list from A2:A5 while skipping blanks, use this formula in B2: =TEXTJOIN(", ",TRUE,A2:A5). If the nonblank cells contain Red, Blue, and Green, the result is Red, Blue, Green. Change the first argument to another delimiter when the output needs different punctuation.

The second argument controls blank handling. TRUE tells TEXTJOIN to ignore empty cells; FALSE keeps their positions in the join and can create repeated delimiters. For example, if A2 contains Red, B2 is blank, and C2 contains Blue, a formula using comma-space and FALSE returns Red, , Blue. The cells are still included in order; the empty cell contributes no text, but the delimiters remain.

Choose Between CONCAT, TEXTJOIN, and &

All three approaches can join cell contents, but each suits a different formula-writing situation:

  • CONCAT: A direct way to combine a range or list of values when no repeated delimiter is needed.
  • TEXTJOIN: A practical option for a range that needs a consistent separator and optional skipping of empty cells.
  • Ampersand (&): A clear choice for a short formula with a few cells and custom text between them.

With a first name in A2 and a last name in B2, this formula entered in C2 uses the ampersand to return Ava Chen: =A2&" "&B2. The operator is not a function, so it needs no parentheses. You can place text between references, and you can chain more than two cells. For example, with a city in C2, =A2&" "&B2&", "&C2 joins the name and city with the specified punctuation.

CONCAT and TEXTJOIN are easier to maintain when a formula includes a long range. Ampersands can make a short formula readable, but a chain with many references and separators is harder to inspect. Conversely, TEXTJOIN may be more than you need for two cells. There is no requirement to use one method throughout a workbook; select the one that makes each formula easiest to understand.

Insert Spaces, Punctuation, and Line Breaks

Excel does not automatically place a space between joined values. A separator must be included in the formula, either as a text argument or as part of an ampersand expression. In a formula, a space is written between straight double quotes, as in " ". Commas and other punctuation are handled the same way.

With a street address in A2, a city in B2, and a postal code in C2, this formula in D2 creates a comma-separated address: =TEXTJOIN(", ",TRUE,A2:C2). The formula skips blank components, which can prevent extra punctuation when one field has no value. For formats with different punctuation rules, adjust the delimiter or build the result with CONCAT or ampersands.

You can also put joined values on separate lines inside one cell. With a name in A2 and an address in B2, enter this in C2: =A2&CHAR(10)&B2. CHAR(10) inserts a line feed in Windows Excel. Turn on Home > Wrap Text for the result cell so the separate lines are visible; you may also need to adjust the row height. The formula still returns one cell, not two.

Preserve the Display of Dates and Numbers

When a formula combines a date or number with text, Excel uses the underlying value rather than necessarily preserving the way the source cell looks. A date may therefore appear as a serial number, and a number formatted with commas or currency symbols may lose that display formatting. This is a frequent reason a concatenation formula looks wrong even though it calculates.

With a name in A2 and a date in B2, use this formula in C2 to show the date as a readable month, day, and year: =A2&" - "&TEXT(B2,"mmmm d, yyyy"). If A2 contains Ava and B2 represents July 4, 2026, the displayed result is Ava – July 4, 2026. TEXT converts the date into the specified text format before it is joined.

With an item name in A2 and a price in B2, this formula in C2 displays two decimal places: =A2&" - $"&TEXT(B2,"#,##0.00"). If the price is 12.5, the result is Item – $12.50. The dollar sign here is typed as literal text; for workbooks used across regions, currency conventions and decimal separators may differ. Choose a number format appropriate for the workbook rather than assuming every reader uses the same regional settings.

TEXT formatting is useful for presentation, but it turns the formatted value into text in the combined result. That is suitable for a label or report heading, not for later arithmetic. Keep the original numeric cells available for calculations.

Fill a Concatenation Formula Down a Column

For a list, create the formula in the first result row, then copy it down. With first names in A2:A20 and last names in B2:B20, enter this formula in C2: =A2&" "&B2. The result in C2 will join that row’s two names. Copy or fill the formula down through C20, and Excel adjusts the relative references so C3 refers to A3 and B3, C4 refers to A4 and B4, and so on.

On Windows, select the formula cell and drag its fill handle at the lower-right corner down the column, or copy it and paste into the destination cells. The keyboard shortcut to copy is Ctrl+C and to paste is Ctrl+V. On Mac, use Command+C and Command+V; the fill handle also works. If the data is in an Excel table, typing a formula in a table column can fill the formula down that calculated column automatically.

When copying a formula, check whether any references should stay fixed. Ordinary references such as A2 change as the formula moves. If a formula must always refer to one particular cell, use an absolute reference such as $A$1. For simple row-by-row concatenation, relative references are normally what you want.

Common Problems and How to Fix Them

  • No spaces appear: CONCAT does not insert separators. Add a space or punctuation explicitly, or use TEXTJOIN with a delimiter.
  • A date becomes a number: Wrap the date reference in TEXT with the desired date format before joining it.
  • There are extra separators: With TEXTJOIN, set the ignore-empty argument to TRUE when blank cells should be skipped. Check for cells that contain spaces, since a cell containing a space is not truly empty.
  • The formula displays instead of calculating: Confirm that the cell is not formatted as Text, and that the formula begins with an equals sign. If needed, change the format to General, then edit and re-enter the formula.
  • Excel reports an unrecognized function: The workbook may be opened in an older Excel version that lacks CONCAT or TEXTJOIN. Use ampersands or CONCATENATE for compatibility.
  • A result includes an error: A referenced error value can flow into the combined result. Find and correct the error in the source cell before relying on the joined text.

Excel formulas commonly use commas between function arguments in the examples here. Some regional settings use semicolons instead, so a formula copied from a comma-based example may need its argument separators changed. The text delimiter inside quotation marks, such as a comma in ", ", is not an argument separator and should remain part of the text.

Frequently Asked Questions

How do I combine two cells in Excel with a space?
With values in A2 and B2, enter =A2&" "&B2 in the result cell. You can also use =TEXTJOIN(" ",TRUE,A2:B2), which skips a blank cell between the values.

Can I concatenate an entire range of cells?
Yes. With values in A2:A10, =CONCAT(A2:A10) joins them without separators. To separate nonblank values with commas, use =TEXTJOIN(", ",TRUE,A2:A10).

What is the difference between CONCAT and TEXTJOIN?
CONCAT joins values without inserting a delimiter. TEXTJOIN lets you specify a delimiter and choose whether empty cells are ignored, so it is usually more convenient for lists with spaces or punctuation.

Does concatenating cells change the original cells?
No. A concatenation formula creates a combined result in the cell where you enter it; the source cells remain unchanged. The result updates when a referenced value changes. To keep a static copy, copy the results and paste values.

How do I keep the date format when joining cells?
Use TEXT around the date reference and provide a format pattern, such as =A2&" "&TEXT(B2,"mmmm d, yyyy"). The date is then included as formatted text rather than its underlying serial value.

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.