Excel: Merge Cell Data Into One Cell

How-to basics · Updated November 19, 2026

To combine values from several Excel cells into one cell without losing the originals, use TEXTJOIN. With first, middle, and last names in A2:C2, enter =TEXTJOIN(" ",TRUE,A2:C2) in D2; if the cells contain Jane, an empty cell, and Smith, the result is Jane Smith. This is different from Excel’s Merge & Center command, which joins cells visually but does not combine their contents.

What merging cell data means in Excel

People use the word merge for two different spreadsheet tasks. One is combining the contents of multiple cells into a single text value, such as assembling a full name from separate name fields. The other is making several worksheet cells appear as one larger cell. Excel treats those tasks differently, and choosing the wrong one can remove data.

When you combine data with a formula, the source cells remain unchanged and the result appears in a separate destination cell. You can add spaces, commas, labels, or line breaks between the values. The result can update when a source value changes, which is useful for reports, labels, exports, and other views of the data.

By contrast, Merge & Center changes the worksheet layout. It combines selected cells into one larger cell area, but Excel retains only the value in the upper-left cell of the selection. Values in the other cells are discarded. If your goal is to keep every value, combine the data with a formula first rather than using Merge & Center.

Choose the right method for your goal

For most tasks, the best method depends on whether you want a lasting combined value or a formula that remains connected to its sources. A formula is usually the safest starting point because it is reversible: you can edit the source cells or the formula without having to reconstruct the original entries.

  • Use TEXTJOIN when you want a delimiter between values and want Excel to skip empty cells.
  • Use the ampersand operator for a short, straightforward combination, especially when you need to control each separator individually.
  • Use CONCAT when you want to join text or ranges without inserting a delimiter automatically.
  • Use Merge & Center only when you want a larger visual cell and are certain that only the upper-left cell’s content needs to remain.

For a reusable list of values in one cell, TEXTJOIN is often the clearest option. If you are preparing a data table for sorting, filtering, or analysis, it may be better to keep each piece of information in its own column instead. A combined display field is convenient, but it is less flexible for later calculations and data cleanup.

Combine adjacent cells with TEXTJOIN

TEXTJOIN takes a delimiter, an instruction about empty cells, and the text or range to combine. The delimiter is placed between values, while TRUE tells Excel to ignore empty cells. This prevents an empty middle-name field, for example, from creating an extra separator.

With values in A2:C2, where A2 contains Jane, B2 is blank, and C2 contains Smith, enter =TEXTJOIN(" ",TRUE,A2:C2) in D2. The result is Jane Smith, with one space rather than two. If B2 later receives a middle name, the result updates to include it.

You can change the delimiter to match the intended output. With the same values in A2:C2, enter =TEXTJOIN(", ",TRUE,A2:C2) in D2 to separate nonblank entries with a comma and a space. For values Jane, blank, and Smith, the result is Jane, Smith. A delimiter is text, so include spaces or punctuation inside its quotation marks exactly as you want them to appear.

To build the formula, select the destination cell, type an equals sign, and enter the function. You can type the cell range directly or select the cells with the mouse while editing. Press Enter to finish. If you need the same combination for many rows, copy the formula down with the fill handle or copy and paste it into the other destination cells; relative references will adjust for each row.

Use ampersands or CONCAT for simple combinations

The ampersand operator joins pieces of text directly and gives you explicit control over the separator. With a first name in A2 and a last name in B2, enter =A2&" "&B2 in C2. If A2 is Jane and B2 is Smith, C2 displays Jane Smith. The ampersand is an operator, not a function, so this approach is easy to read for a small number of cells.

For a longer row of values, repeated ampersands can become difficult to maintain. If values are in A2:C2 and you want to join them with no separator, enter =CONCAT(A2:C2) in D2. With Jane, blank, and Smith in that range, the result is JaneSmith. CONCAT does not add spaces or punctuation on its own, so use TEXTJOIN when you want a delimiter between entries.

TEXTJOIN, CONCAT, and the ampersand operator create a text result; they do not physically move the source values into the destination cell. Their formulas recalculate when the referenced cells change. In Microsoft 365 for Windows, these functions are available in current Excel. If a workbook must work in an older Excel version where TEXTJOIN or CONCAT is unavailable, the ampersand operator is a simple alternative for combining a modest number of cells.

Add line breaks, clean spaces, and handle empty cells

A combined cell can contain multiple lines. With items in A2:C2, enter =TEXTJOIN(CHAR(10),TRUE,A2:C2) in D2 to put each nonblank item on a separate line. For the result to display as separate lines, select D2 and choose Home > Wrap Text. The line breaks are inside the cell; they do not create additional worksheet rows.

Ignoring empty cells does not remove unwanted spaces that are already inside a nonempty cell. For example, a first-name cell that ends with a space can create a double space when joined with a separator. With first, middle, and last names in A2:C2, enter =TEXTJOIN(" ",TRUE,TRIM(A2),TRIM(B2),TRIM(C2)) in D2 to remove extra leading and trailing spaces from each item before joining. TRIM also reduces repeated internal spaces to single spaces, so use it only if that cleanup is appropriate for the source text.

There is a difference between a genuinely empty cell and a cell whose formula returns an empty string. TEXTJOIN with TRUE is designed to skip empty values, including empty strings in common cases. It does not know whether a value should be omitted for business reasons, however. If a cell contains a placeholder such as N/A or a dash, Excel treats that as content and includes it. Clean or adjust the source data if those placeholders should not appear.

Join dates, numbers, and formatted values

When a formula combines a number or date with text, the displayed result may not match the number format shown in the source cell. Excel stores dates as serial numbers, and a currency or percentage format is generally a display instruction rather than part of the underlying value. A joined result may therefore show a raw number unless you explicitly format it as text.

With a date in A2, enter =TEXT(A2,"mmm d, yyyy") in B2 to return a text version such as Nov 2, 2026, assuming A2 contains that date. The format code controls the displayed wording. If you then combine B2 with other cells, the date appears in that chosen format rather than as its underlying serial value.

With a price in A2 and a product name in B2, enter =B2&" - "&TEXT(A2,"$#,##0.00") in C2 to display a value such as Notebook – $12.50 when A2 contains 12.5. TEXT converts the number to formatted text for the combined result. Once it is part of a text string, the price is no longer a numeric value for arithmetic; keep the original numeric cell for calculations.

Be deliberate about date and number formats when creating a file for another system. A formatted string can be useful for a report or label, but it may not be suitable for sorting dates chronologically or totaling amounts. Preserve the original date and number columns when those values may be needed later.

Make a permanent combined value

A formula result changes if its source cells change. If you need a fixed text value for an upload, a handoff, or a final report, copy the formula results and paste them as values in the destination cells. In Excel for Microsoft 365 on Windows, select the formula cells, press Ctrl+C, then use Home > Paste > Values. You can also right-click the destination and choose the Values paste option.

After pasting values, the combined text remains, but the formulas and links to the original cells are removed. Check a few rows before deleting or changing the source columns. If you want both a fixed result and the ability to revise the original information, retain a copy of the source data or keep the formulas in a separate column.

Excel for Mac uses the same formulas. Keyboard shortcuts differ: Command+C copies selected cells on Mac, while Ctrl+C does so on Windows. The ribbon’s paste-values option is also available in current desktop editions, although the exact placement can vary slightly by Excel release. Excel for the web supports standard worksheet formulas and offers paste options, but its ribbon layout may differ from the Windows desktop application.

What Merge & Center does—and why it is risky for data

To visually merge cells in Excel for Microsoft 365 on Windows, select the cells, then choose Home > Merge & Center. The dropdown beside the command also includes other merge options, such as Merge Across and Merge Cells. These commands affect cell layout; none of them concatenates the contents of all selected cells.

If several selected cells contain values, Excel keeps the upper-left value and removes the others as part of the merge. For example, merging A2:C2 when A2 contains Jane and B2 and C2 contain other text does not create a combined name. It leaves the value from A2 and discards the other contents. If you need all three values, first create a formula result in another cell, confirm it is correct, and only then consider whether a visual merge is still necessary.

Merged cells can also complicate sorting, filtering, copying, and selecting ranges, especially when the merged layout is repeated within a data table. For headings, a centered heading across columns may be more appropriate than merging cells. Excel’s Center Across Selection alignment can provide a similar appearance without turning the selected cells into one merged cell; find it in the Format Cells dialog under Alignment, in the Horizontal alignment options.

Common problems and practical checks

If Excel displays a formula as text instead of calculating it, check that the destination cell is not formatted as Text and that the formula begins with an equals sign. Change the cell format to General, then re-enter the formula. A leading apostrophe can also make Excel treat an entry as text. In some regional settings, Excel uses semicolons rather than commas between function arguments; if a valid formula is rejected, check the list-separator setting used by that installation.

If the result has missing values, inspect the referenced range and confirm that the cells actually contain the expected data. A formula may be pointing at the wrong row after copying, or a source may be genuinely blank. If the result has extra spaces, use TRIM when suitable and review whether the separator itself includes a leading or trailing space.

Excel cells can hold up to 32,767 characters of text. A very long joined result may exceed that limit, so combining large ranges into one cell is not a substitute for keeping records in separate rows. Also consider whether the combined text will be readable: a long comma-separated list may be better presented as separate worksheet rows, a wrapped multi-line cell, or a report outside the data table.

Before changing a workbook’s structure, save a copy if the source values matter. In particular, do not use Merge & Center on a selection containing multiple values as a way to combine them. If you have already merged cells and the contents disappeared, Undo may restore the earlier state if it is still available; otherwise, recover the missing values from the original data or a saved copy.

Frequently Asked Questions

How do I merge two cells without losing data?
Use a formula such as TEXTJOIN or the ampersand operator in a separate cell to combine the contents first. Excel’s Merge & Center command does not preserve all values in a multi-cell selection; it keeps only the upper-left cell’s content.

What formula combines cells with a space between them?
With text in A2 and B2, enter =TEXTJOIN(" ",TRUE,A2:B2) in another cell. The result places a space between nonblank values and skips empty cells.

How can I combine cells and skip blanks?
Use TEXTJOIN with TRUE as its second argument, such as =TEXTJOIN(", ",TRUE,A2:C2) when the values are in A2:C2. It skips empty entries and separates the remaining values with a comma and a space.

Can I combine cells into one cell and keep the formula result fixed?
Yes. Copy the formula result, then paste it using the Values option. The resulting text is fixed and no longer updates when the source cells change.

Can I combine cells from different rows?
Yes. TEXTJOIN can take a range that runs down a column as well as across a row. For a list that should remain easy to sort, filter, and analyze, though, keeping each record in its own row is usually more practical than packing many records into one cell.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.