Excel: Merge Data From Multiple Cells Into One Cell

How-to basics · Updated November 19, 2026

Yes. To combine cell contents into one result in Excel for Microsoft 365, use a formula such as the ampersand operator. With a first name in A2 and a last name in B2, enter =A2&" "&B2 to return one value, such as Ravi Patel. This joins the text without merging the worksheet cells themselves.

What “merge” means in Excel

People use “merge cells” to mean two different things in Excel. One meaning is combining the contents of separate cells into a single text result, which is usually what you want when joining names, addresses, labels, or codes. The other is using Excel’s Merge Cells formatting command to make several worksheet cells appear as one larger cell. Those operations are not interchangeable.

A formula or data-cleaning tool can combine the values from several cells while leaving the source cells intact. The resulting text can then be copied, searched, exported, or used in another formula. By contrast, Merge Cells changes the worksheet layout. If multiple selected cells contain data, Excel keeps only the upper-left cell’s content and removes the other contents. That can destroy information rather than join it.

For lists and records, joining values into a new column is generally the safer choice. Keep the original columns until you have checked the results and know you no longer need them. This is especially important for names, addresses, and identifiers, where a missing separator or a lost value can be difficult to spot later.

Join cells with a formula

The ampersand operator (&) is a direct way to join values and add separators. It is easy to read in a short formula and works well when you know which cells you want to combine. In the opening example, the space between the quotation marks prevents the first and last names from running together.

With A2 containing Ravi and B2 containing Patel, enter =A2&" "&B2. The result is Ravi Patel. To join three cells with a comma and a space, add that delimiter between references; for example, the same method can produce a city, state, and postal code in a single display field.

CONCAT is another option when you want to join a range or several values directly. With A2:C2 containing the text AB, 12, and X, enter =CONCAT(A2:C2). The result is AB12X. CONCAT does not add spaces or punctuation automatically, so include separators in the formula if the pieces need them. In current Microsoft 365, you can use CONCAT for this kind of joining; older workbooks may also contain the legacy CONCATENATE function.

For ranges where some cells may be empty, TEXTJOIN is often more convenient because it applies a delimiter and can skip empty cells. With A2:C2 containing North, a blank cell, and Depot, enter =TEXTJOIN(" - ",TRUE,A2:C2). The result is North – Depot, with no extra separator for the blank cell. The second argument, TRUE, tells Excel to ignore empty cells. Set it to FALSE if you want empty cells to occupy a position between delimiters.

  • Use & when you are joining a few known cells and want full control over each separator.
  • Use CONCAT when you want a straightforward join across a range or list of values.
  • Use TEXTJOIN when a range needs a repeated delimiter and may contain blanks.

Choose a separator that makes the result readable

Joining values without a delimiter can make the result hard to interpret. A space is suitable for a full name; a comma and space can separate city and region; a hyphen may work for a label. Choose a separator that does not create confusion with the data itself. If the source values can already contain commas, for example, a comma-separated result may be ambiguous when exported or split again.

Think about what the combined field will be used for. A display label can be designed for people to read, while a key intended for matching records should use a consistent structure. Avoid adding optional punctuation or inconsistent spaces to identifiers, because two values that look similar may not match exactly in a lookup or comparison.

Dates and numbers need special attention. When Excel joins a date cell directly to text, it may show the underlying date serial number rather than the date format you see in the worksheet. Use TEXT to specify the display format. With A2 containing the label Order and B2 containing the date May 4, 2026, enter =A2&" - "&TEXT(B2,"mmm d, yyyy"). The result is Order – May 4, 2026. Choose a format code that suits your audience, and remember that the formula creates text; the combined result is no longer a date value for date calculations.

Fill the formula down a column

For a list, put the formula in the first output row, check that it refers to the correct source cells, and fill it down. If the formula is in C2 and the source values are in A2 and B2, copy or drag the formula down the column. Excel adjusts relative references for each row: the next row uses A3 and B3, then A4 and B4, and so on.

To fill a formula with the mouse, select its cell and drag the small square at the lower-right corner of the selection, called the fill handle. You can also copy the formula, select the destination cells, and paste. When the data is an Excel table, entering a formula in a table column usually fills the formula through that column automatically. Tables also expand as you add rows, which can make a growing list easier to manage.

Check several rows after filling down, including rows with blank source cells and the last row in the list. A formula can be syntactically correct but still join the wrong columns, especially when the data includes hidden columns or begins on a different row than expected.

Use Flash Fill for a one-time transformation

Flash Fill can infer a pattern from examples you type and fill the remaining rows. It is useful when you need a quick, fixed result rather than a formula that stays linked to its source. For example, if columns A and B contain first and last names, type the desired full name in the first output cell, then begin the next example. Excel may recognize the pattern and preview the rest of the column.

  1. Make sure the source columns are next to, or clearly associated with, the output column.
  2. Type the desired combined result for the first row. Include the exact space or punctuation you want.
  3. Start typing the next row’s result. If Excel displays an appropriate preview, accept it with Enter.
  4. If no preview appears, use Data > Flash Fill. In Windows Excel, Ctrl+E is the Flash Fill shortcut.

Flash Fill produces completed values, not formulas linked to the original cells. If you later change a first or last name, the filled result will not update automatically. Review the output carefully: patterns can be misread when rows vary, source cells are inconsistent, or some records contain extra names. On a Mac, use the Data tab’s Flash Fill command if it is available in your Excel version; the ribbon command avoids relying on a Windows-only key combination.

Combine columns with Power Query

Power Query is useful for repeatable cleanup, especially when you import or refresh a dataset regularly. Instead of placing a formula in every worksheet row, you can define a transformation in the query and apply it again when the source data changes. Power Query is available in Microsoft 365 for Windows, though the available connectors and editing experience can vary by platform and Excel build.

  1. Format the source range as a table, or select a cell in the range. Choose Data > From Table/Range and confirm the table range if Excel asks.
  2. In Power Query Editor, select the columns to combine. Use Ctrl-click on Windows to select multiple non-adjacent columns.
  3. Choose Transform > Merge Columns, select a separator, and enter a suitable new column name.
  4. Choose Home > Close & Load to return the transformed data to Excel.

Power Query’s merge operation combines selected columns into a new column in the query; it does not mean the same thing as merging worksheet cells. Decide whether to keep or remove the original columns in the query, and check the output before loading it. When the source changes, refresh the query to apply the saved transformation again. The result is not refreshed in the same way as a worksheet formula, so use the refresh command when you need updated output.

Keep a fixed result or a live formula?

Formula results update when their referenced cells change, which is valuable when the source data is still being edited. But a formula cell contains a calculation, not just the resulting text. If you need to send a stable copy, make an archive, or remove the original columns, convert the formulas to values after checking them.

To do that in Windows Excel, copy the formula results, then use Home > Paste > Values in the destination area. The pasted text remains even if you later delete the source columns. On a Mac, use the Paste Values command from the Home tab or the paste options menu; keyboard shortcuts can differ by version and keyboard settings. Avoid overwriting your only copy of the source data until you have verified the pasted values.

Choose the method based on how you will use the result:

  • For a live worksheet that should respond to edits, use a formula.
  • For a quick, one-off pattern that you have checked, Flash Fill may be faster.
  • For a repeatable import or cleaning process, use Power Query and refresh it when the source changes.
  • For a visual heading spanning several cells, use Merge Cells only when you do not need to preserve separate cell contents.

Common problems and how to avoid them

Missing spaces or punctuation: Excel joins exactly what the formula specifies. Inspect the separators between references and add the space, comma, or other character you need. A formula that returns RaviPatel has not failed; it simply has no space in its instructions.

Unexpected extra separators: A basic ampersand formula adds its separator whether or not a source cell is blank. TEXTJOIN can skip empty cells when its ignore-empty argument is TRUE. If blanks have a particular meaning in your data, decide whether skipping them is appropriate rather than assuming it is.

Dates appear as numbers: Applying a cell format to the formula result may not fix the underlying conversion. Use TEXT around the date reference in the formula when you need a specific date display, as shown above.

The combined result does not change: Flash Fill and pasted values are fixed text. Formulas recalculate from their references, while Power Query output changes after a refresh. Confirm which method created the result before troubleshooting.

Merge Cells seems to delete data: That command is for layout, not text concatenation. Undo immediately if you used it on cells with separate contents and the change is still undoable; otherwise, restore the original data from a backup or version history. For future work, create a separate output column with a formula or query.

Leading zeros disappear: Excel may treat codes such as 0042 as numbers and remove the zeros before you join them. Store identifiers as text when leading zeros are meaningful, or construct the required text representation deliberately. A formatted display alone does not always mean the underlying value includes those zeros.

Frequently Asked Questions

Does merging cells combine their text?
No. Merge Cells combines the worksheet area for formatting and keeps only the upper-left cell’s content when multiple cells contain data. Use a formula, Flash Fill, or Power Query to join the contents instead.

What is the simplest formula to combine two cells?
Use the ampersand operator and add a delimiter between the references. For example, joining A2 and B2 with a space uses =A2&" "&B2. Replace the space with the punctuation or separator your result needs.

How do I combine cells and ignore blanks?
Use TEXTJOIN with its ignore-empty argument set to TRUE. Give it the delimiter you want and the range to combine. This avoids adding a separator for empty cells within that range.

Can I combine cells without a formula?
Yes. Flash Fill can recognize a pattern from examples and create fixed values, while Power Query can save a repeatable transformation for imported data. Both behave differently from formulas, so choose based on whether the result needs to update when the source changes.

Can I separate the combined text again later?
Often, but it depends on the separator and the original data. Excel’s Text to Columns feature can split text using a delimiter, but values that already contain that delimiter may split incorrectly. Keep the original columns when you may need to recover the separate fields.

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.