Excel Merge Text From Two Cells: Formulas and Tips

Formulas & functions · Updated November 21, 2026

To merge text from two cells in Excel, join their references with the ampersand operator: if the text is in A2 and B2, enter =A2&" "&B2 in another cell to put a space between the two values. For example, “Maya” in A2 and “Chen” in B2 returns “Maya Chen.” Use a different separator, such as a hyphen, by changing the text between the quotation marks.

The quickest way to combine two cells

In Microsoft Excel for Microsoft 365 on Windows, select an empty cell where you want the combined result, type the formula, and press Enter. The formula joins the contents of A2 and B2, with one space in between. The result appears in the formula cell; the source cells remain separate and unchanged. To use the same method with other rows, drag the fill handle—the small square at the bottom-right corner of the selected cell—downward. Excel adjusts the row references automatically.

The ampersand operator is often the simplest choice because it works in a wide range of Excel versions and makes the separator easy to see. With A2 containing “Maya” and B2 containing “Chen,” the formula returns “Maya Chen.” If you want “MayaChen” with no space, join the references directly. If the cells contain a first name and last name, the space is usually important; for an ID or code, it may not be.

For no separator, with the source text in A2 and B2, use =A2&B2. If A2 contains “North” and B2 contains “Star,” the result is “NorthStar.” For a hyphen separator with the same cell layout, use =A2&"-"&B2, which returns “North-Star.” The quotation marks tell Excel that the hyphen is literal text, rather than a cell reference or an operation.

Choose the separator you need

The separator is simply text placed between the cell references. Put it inside straight double quotation marks. You can use a space, punctuation, or a label, and you can include more than one character. This is useful for names, addresses, product codes, and descriptions, where the right punctuation can make the combined value easier to read or use.

  • Space: joins a first and last name as “Maya Chen.”
  • Comma and space: produces a format such as “Chen, Maya.”
  • Hyphen: combines parts of a code as “AB-104.”
  • Slash: can display two short labels as “East/West.”
  • Words: can join a city and country as “Oslo, Norway.”

For a comma-and-space separator, with the first text in A2 and the second in B2, enter =A2&", "&B2. If A2 contains “Chen” and B2 contains “Maya,” the result is “Chen, Maya.” If the separator needs to appear at the beginning or end instead, include it as a quoted text item before the first reference or after the last one.

Use CONCAT or TEXTJOIN instead

Excel offers functions as alternatives to the ampersand operator. CONCAT combines text values or ranges, and is available in Microsoft 365. For two cells and a space, with the source values in A2 and B2, enter =CONCAT(A2," ",B2). With “Maya” and “Chen” in those cells, the result is “Maya Chen.” Unlike the ampersand method, CONCAT takes a list of arguments inside parentheses; it does not add a separator by itself, so include the space as an argument when you want one.

TEXTJOIN is handy when you want one separator applied between several values, or when some cells might be blank. With the text in A2 and B2, enter =TEXTJOIN(" ",TRUE,A2,B2) to join them with a space and tell Excel to ignore empty cells. If A2 is “Maya” and B2 is “Chen,” the result is “Maya Chen.” In this function, the first argument is the delimiter, the second says whether to ignore empty cells, and the remaining arguments are the text to join. TEXTJOIN is available in Microsoft 365 and newer Excel versions, including Excel 2019.

For exactly two cells, the ampersand formula is usually easiest to read. Choose CONCAT if you prefer a function or need to combine a range. Choose TEXTJOIN when you want a delimiter and need empty cells skipped. Older workbooks may contain CONCATENATE, a legacy function that still works in many Excel versions, but Microsoft recommends CONCAT for new formulas. The ampersand operator avoids having to choose among function versions when all you need is a basic join.

What happens when one cell is blank?

A blank cell is treated as an empty string when joined with the ampersand operator. That means a formula with a space separator can leave an extra space if one of its two cells is blank. The space may be hard to notice in a worksheet, but it can matter when the result is copied into another system, compared with another value, or used in a lookup. TEXTJOIN with its ignore-empty option can avoid separators for blank inputs.

For a two-cell name where A2 may be blank and B2 may contain a surname, with the values in A2 and B2, enter =TEXTJOIN(" ",TRUE,A2,B2). If A2 is empty and B2 contains “Chen,” the result is “Chen,” without a leading space. If both cells are empty, the result is empty. This behavior can be preferable for lists with optional middle names or address components.

Ignoring empty cells is not the same as removing spaces that are already inside a cell. For example, if A2 contains “Maya ” with a trailing space and B2 contains “Chen,” joining them with another space can create two spaces between the names. Check the source data if the result looks uneven. Excel’s TRIM function can remove extra ordinary spaces from text, but it does not remove every kind of whitespace that may come from copied data or other systems.

Preserve dates, numbers, and display formats

When Excel joins a number or date with text, the result may show the underlying value rather than the way the cell is formatted. A date stored as a number, for example, may appear as a serial number in the combined text. Currency symbols and leading zeros can also be lost because cell formatting changes how a value is displayed, not necessarily the value used by a formula.

To control the appearance of a numeric value, wrap it in TEXT and specify a format. With a description in A2 and the numeric amount 1250.5 in B2, use =A2&": $"&TEXT(B2,"#,##0.00"). If A2 contains “Total” and B2 contains 1250.5, the result is “Total: $1,250.50” in a typical English-language setting. The format code requests comma grouping and two decimal places; separators and currency conventions can vary by Excel’s regional settings.

For a date, with a date value in A2 and a label in B2, enter =B2&": "&TEXT(A2,"mmm d, yyyy"). If B2 contains “Due” and A2 holds January 15, 2026, the result is “Due: Jan 15, 2026.” The TEXT function turns the value into formatted text, so the combined result is no longer a date value that Excel can directly sort or calculate as a date. Keep the original date cell if you need date arithmetic later.

Keep the result linked or make it permanent

A formula-generated result updates when its source cells change. That is useful when the combined text is a live label, report field, or name that should reflect edits. It also means the result depends on the original cells and formula remaining available. If you delete or replace a source value, the combined result changes accordingly.

If you need a fixed text result, copy the formula cells and paste their values. In Excel for Microsoft 365 on Windows, copy the results, then use Home > Paste > Paste Values. This replaces the formulas with their current displayed text. The original source cells can then be edited without changing those pasted values. Consider keeping a copy of the workbook or source data first if the formulas are important, because replacing them with values removes the live link.

On Excel for Mac, the same general method applies: copy the formula cells and choose the values-only paste option from the Home tab’s Paste menu. In Excel for the web, use the Paste options available on the Home tab after copying. The exact button presentation can vary by interface, but the goal is to paste values rather than formulas.

Common problems and fixes

  • The formula shows as text: the destination may be formatted as Text, or the entry may start with an apostrophe. Change the cell format to General, then re-enter the formula.
  • The cells join without a space: Excel does not insert punctuation automatically. Add a quoted separator between the references.
  • The result has odd spacing: inspect source cells for leading or trailing spaces, and decide whether TEXTJOIN should ignore blank cells.
  • A date or amount looks different: format the value with TEXT inside the formula, or keep it in its own cell and combine only when display text is required.
  • The formula returns an error: check that the cell references exist and that quotation marks and parentheses are paired. In some regional configurations, Excel may use semicolons instead of commas between function arguments.

Another common misunderstanding is that combining text is the same as merging worksheet cells. A text formula creates a new value in a separate cell; it does not remove or combine the source cells. By contrast, Excel’s Merge & Center command combines selected cells’ layout into a larger cell, and only the upper-left cell’s content is retained when multiple selected cells contain data. If you need to preserve both values, combine the text with a formula rather than using Merge & Center.

Frequently Asked Questions

What is the formula to merge two cells in Excel with a space?
With the values in A2 and B2, use =A2&" "&B2. It joins the two values with one space and leaves the original cells intact.

How do I combine two cells without a space?
With the text in A2 and B2, use =A2&B2. This puts the second value immediately after the first.

Can I combine cells with a comma or hyphen?
Yes. Put the desired separator in quotation marks in the formula, such as a comma followed by a space or a hyphen. The separator is ordinary text, so you can use other characters too.

How do I merge cells but keep both values?
Use a text formula to combine the values in a separate cell. Do not use Merge & Center when both source cells contain information, because that command does not concatenate their contents.

Will the combined text change if I edit a source cell?
Yes, if the result is still a formula. To keep the current result fixed, copy it and use Paste Values; the pasted text will no longer update from the source cells.

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.