How to Copy and Concatenate Text in Excel with Formulas

Formulas & functions · Updated November 20, 2026

To combine text from two cells, put the values in A2 and B2, then enter =A2&" "&B2 in C2; if A2 contains Maya and B2 contains Chen, the result is Maya Chen. Fill the formula down to join other rows, then use Home > Paste > Values if you want to copy the finished text without keeping formulas. This guide explains that method, alternatives, and what to check when the result is not right.

What You’ll Need

  • A workbook in Microsoft Excel for Microsoft 365 on Windows, with the text you want to join in cells. The examples use A2 and B2 for two pieces of text and C2 for the result.
  • A blank destination column for the combined text. If you want to replace existing source data, make a backup or work in a copy first.
  • For the examples, imagine A2 contains Maya and B2 contains Chen. You can substitute your own cell references and separator, such as a space, comma, hyphen, or no separator.

Step-by-Step

  1. Arrange the source text. Put each piece you want to join in its own cell, with one record per row. For example, place first names in column A and surnames in column B. Keep the destination column, such as C, clear so the formula results do not overwrite the source. If your data has headings, leave them in row 1 and start with row 2.
  2. Choose how the pieces should be separated. Decide whether the combined text needs a space, comma and space, hyphen, or no separator. A separator must be included in the formula; Excel will not automatically add spaces between cell values. For names, a single space is usually suitable. For a list of words, a comma and space may be clearer.
  3. Enter a formula in the first result cell. With the first text in A2 and the second in B2, type the following in C2 and press Enter: =A2&" "&B2. The ampersand joins the cell contents, and the quoted space inserts a space between them. With Maya in A2 and Chen in B2, C2 displays Maya Chen. To join the text with no gap, use =A2&B2. To use a comma and space, use =A2&", "&B2.
  4. Use CONCAT if you prefer a function. With the same layout—text in A2 and B2 and the result in C2—enter =CONCAT(A2," ",B2) in C2. It returns Maya Chen for the example values. CONCAT joins the items in the order supplied, and the quoted space is a separate item. Unlike the ampersand operator, CONCAT can take a range as an argument, but it does not add separators automatically.
  5. Join several cells with TEXTJOIN when a separator is needed. With the pieces in A2:C2 and the result in D2, enter =TEXTJOIN(" ",TRUE,A2:C2). This joins nonempty cells from left to right with a space between them; for example, Maya, Ann, and Chen in A2:C2 produce Maya Ann Chen. The TRUE argument tells Excel to ignore empty cells. To separate the same range with commas and spaces, use =TEXTJOIN(", ",TRUE,A2:C2). TEXTJOIN is available in Microsoft 365 and supported newer Excel versions, including Excel 2019 and later.
  6. Copy the formula to the remaining rows. Select C2. Point to the small square at the lower-right corner of the selection, called the fill handle, and drag it down to the last row. Excel adjusts relative references for each row: the formula in C3 refers to A3 and B3. For a continuous neighboring data range, you can also double-click the fill handle to fill down. Check the last few rows to confirm the formula reached all intended records.
  7. Copy the combined results. Select the result cells, such as C2:C20, and press Ctrl+C on Windows. On a Mac, use Command+C. Click the destination cell or select the destination range. To keep a live formula, paste normally with Ctrl+V on Windows or Command+V on Mac. The pasted formulas may still refer to their original source cells, depending on where you paste them.
  8. Paste plain text values if the result should be fixed. To keep only the displayed combined text, copy the formula results, then choose Home > Paste > Values from the ribbon. This pastes the current text rather than the formulas, so it will not change if the original cells are later edited. If you need a particular destination, select its top-left cell before choosing Values. Confirm that the output looks correct before deleting or changing the source cells.

Common Mistakes

Forgetting the separator: A formula such as =A2&B2 combines the contents exactly as written. If A2 is Maya and B2 is Chen, the result is MayaChen. Include a quoted space or other delimiter when the joined text needs one.

Adding a space outside the quotation marks: Text separators must be enclosed in straight double quotation marks. In =A2&" "&B2, the space is between the quotes. Typing a space between formula elements without quotes does not create a reliable text separator and may cause a formula error.

Expecting blank cells to disappear with every method: TEXTJOIN can skip empty cells when its second argument is TRUE. The ampersand operator and CONCAT do not apply that same skip-empty option. A blank middle cell may therefore leave two spaces or separators. Inspect the source data or use TEXTJOIN when skipping empty entries is appropriate.

Copying formulas when you meant to copy text: A normal paste can bring the formula along. If you need a fixed result for an upload, report, or handoff, choose Paste Values and verify the pasted cells before removing the original data.

Overwriting source cells too soon: If you paste combined values over the cells the formula references, the formula may change or lose its inputs. Put results in a separate column first, then confirm the values before replacing or deleting anything.

Tips

  • Use a separate output column until you have checked the combined text. This makes it easy to compare each result with its source pieces and undo an incorrect approach.
  • For full names, use a space as the delimiter. For labels or mailing details, choose punctuation that matches the intended format; for example, use a comma and space between a city and region.
  • If you need a separator between many cells, TEXTJOIN is often easier to read than typing a separate ampersand between every reference. Set the delimiter once in its first argument, then provide the range.
  • Make sure the destination cells are wide enough to inspect the result. A narrow column may show number signs or hide part of the text visually, even though the cell contains the full value. Widen the column or use Home > Format > AutoFit Column Width.
  • When the source values may change and you want the combined text to update, keep the formulas. When the text is a final snapshot, paste values. The choice depends on whether the output should remain linked to the source cells.
  • If the workbook uses a different regional list separator, Excel may expect semicolons instead of commas between function arguments. Use the separator Excel accepts on your computer; do not change the quoted delimiter text inside the formula.

Troubleshooting

The formula appears as text instead of calculating. The destination cell may have the Text number format, or the entry may start with an apostrophe. Change the cell format to General using Home > Number Format > General, then re-enter the formula. Changing the format alone may not recalculate an entry already stored as text; click into the cell and press Enter after correcting it.

Excel shows an error as soon as you enter the formula. Check that the formula begins with an equals sign, that parentheses are balanced when using a function, and that all text delimiters use straight double quotes. For CONCAT or TEXTJOIN, confirm your installation recognizes the function. Microsoft 365 includes these functions. If Excel rejects commas between function arguments, your regional settings may require semicolons instead.

The output is missing a space or punctuation. Edit the formula and check the quoted separator. In the example =A2&" "&B2, there must be one actual space between the quotation marks. A delimiter that is absent or placed outside the quotes will not appear as intended.

Only the first row combined correctly. Check that the formula was filled down far enough and that the source columns contain data in the rows you expect. Select a later result cell and inspect its formula: C3 should normally refer to A3 and B3, not continue referring to A2 and B2. If you copied and pasted the formula manually, relative references normally adjust, but absolute references marked with dollar signs, such as $A$2, stay fixed.

The pasted results change unexpectedly. You may have pasted formulas rather than values, or the formulas may still point to the original source cells. Undo immediately if the paste affected data you need, then copy the results again and select Home > Paste > Values. If you have already saved or closed the workbook, use a backup or version history if available.

Extra spaces remain in some results. The source cells may already contain leading or trailing spaces, or blank cells may be contributing separators with a method other than TEXTJOIN. Check the original cells and decide whether to clean them or use TEXTJOIN with its ignore-empty argument set to TRUE. Do not remove spaces blindly if they are meaningful in the source text.

Frequently Asked Questions

What is the simplest way to concatenate text in Excel?
Use the ampersand operator between cell references. For two cells with a space between them, the example formula is =A2&" "&B2. It is quick to enter and works well for a small number of pieces.

Is CONCAT better than the ampersand operator?
Neither is always better. CONCAT can be convenient for several cells or a range, while ampersands make simple joins easy to read. Both require you to add a delimiter yourself if you want spaces or punctuation between pieces.

How do I join cells and skip blanks?
Use TEXTJOIN and set its second argument to TRUE. With text in A2:C2 and the result in D2, =TEXTJOIN(" ",TRUE,A2:C2) joins nonempty cells with spaces and ignores empty cells in that range.

Can I concatenate text and copy it into another workbook?
Yes. Copy the result cells and paste them into the other workbook. To avoid bringing formulas that depend on the original workbook, choose Home > Paste > Values. Review the destination to ensure its formatting and text are as expected.

Will the combined text update when I edit the source cells?
Yes, if you keep the formula in the result cell. Excel recalculates it when referenced values change. If you paste the result as a value, it becomes fixed text and will not update when the source changes.

Can I concatenate numbers and dates with text?
Excel can combine numeric or date values with text, but their displayed formatting may not carry over as expected; dates can appear as serial numbers. For a controlled format, use TEXT to format the value before joining it. Check the resulting string before copying it as a fixed 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.