How to Combine Columns in Excel Without Losing Data

How-to basics · Updated November 20, 2026

To combine two columns in Excel without removing their original contents, put the result in a new, empty column. With first names in A2 and last names in B2, enter =A2&" "&B2 in C2, then fill the formula down. This creates a combined value while leaving columns A and B unchanged. If you need the combined results to stay after the source columns are moved or deleted, copy the results and paste them as values.

What You’ll Need

  • An Excel workbook, preferably with a backup if the data is important.
  • The columns you want to combine, with one record per row and a clear plan for the separator, such as a space, comma, or hyphen.
  • An empty destination column for the combined results. Avoid putting the formula over either source column.

Step-by-Step

  1. Check the source columns. Confirm that the values you want to join are on the same rows. For example, if A2 contains a first name and B2 contains the matching last name, those are the two cells to combine for that person. Check a few rows for blank cells, extra spaces, dates, or numbers with leading zeros. If the headers are in row 1, your first data row will usually be row 2.
  2. Insert or choose an empty destination column. If C is empty, use it; otherwise, insert a new column by right-clicking its column letter and choosing Insert. Add a useful header such as Full Name in C1. Keeping the output in a separate column is important: it prevents a formula from replacing its own inputs and gives you a way to compare the result with the originals.
  3. Enter a formula that joins the cells. With first names in A2 and last names in B2, enter =A2&" "&B2 in C2. The ampersand joins text, and the quoted space supplies a readable separator. If A2 is Ava and B2 is Chen, C2 displays Ava Chen. Press Enter to calculate the result. You can replace the space inside the quotation marks with another separator, such as a hyphen or comma followed by a space.
  4. Use TEXTJOIN when some cells may be empty. With the values to combine in A2:C2, enter =TEXTJOIN(" ",TRUE,A2:C2) in the destination row. This joins the cells with spaces and ignores empty cells. For example, if A2 is Ava, B2 is blank, and C2 is Chen, the result is Ava Chen rather than a name with an awkward extra space. TEXTJOIN is available in Microsoft 365 and newer Excel versions; it is included in the Excel for Microsoft 365 assumed here.
  5. Fill the formula down the rows. Select the formula cell, then point to the small square at its lower-right corner, called the fill handle. Double-click the handle to fill down alongside an adjacent, continuous data column. Alternatively, drag it down to the last record. You can also select the formula cell and the cells below it in the destination column, then press Ctrl+D on Windows to fill down. Excel adjusts relative references automatically, so the next row should refer to A3 and B3, then A4 and B4, and so on. On Mac, use Command+D to fill down.
  6. Check several results before relying on the column. Compare the first, middle, and last rows with their source cells. Look for missing separators, unexpected blanks, repeated values, and rows that did not fill. If the source columns have filters or a particular order, make sure the joined values still correspond to the same records. Keep the original columns until you are satisfied with the result.
  7. Make the results permanent if you need to remove the source columns. Select the completed results and copy them with Ctrl+C on Windows or Command+C on Mac. In the destination, use Home > Paste > Values to replace the formulas with their current displayed results. You can also right-click and choose the Values paste option. Confirm that the cells now contain the combined text before deleting or moving any source columns. Formula results depend on their source cells; pasted values do not.
  8. Save the workbook. Save after checking the output. If you want to keep both the flexible formula version and a fixed-value version, duplicate the worksheet first, then paste values on the copy. This lets you retain an editable original while using a standalone combined column elsewhere.

Common Mistakes

Typing over a source column. If the formula is entered in A2 while it refers to A2, it can create a circular reference or overwrite useful data. Put the output in a separate column and keep the source intact until you have verified the results.

Using Merge & Center to join cell contents. Merge & Center combines the cell area, not the text from several cells. When you merge cells that contain data, Excel keeps the upper-left cell’s contents and can discard the rest. Use a formula to combine values. If you mean visually joining cells into a larger cell, that is a different task and does not preserve all their separate contents.

Forgetting the separator. A formula such as =A2&B2 joins text directly, so Ava and Chen become AvaChen. Add the desired separator explicitly, or use TEXTJOIN. Check punctuation carefully when making addresses, labels, or names.

Assuming formulas are permanent text. A formula may look like a finished value, but it still relies on its source cells. Deleting a source column can produce errors or change the output. Paste values first if the combined results must stand alone.

Ignoring spaces already in the data. A source cell may contain a trailing space, so adding another separator can leave an extra gap. Conversely, trimming every cell may remove meaningful spaces in some kinds of text. Inspect representative rows and clean the source deliberately rather than assuming all entries are consistent.

Tips

Choose a separator that makes the joined information easy to read and split mentally. Use a space for names, a comma and space for a city-and-region label, or a hyphen for a code with distinct parts. A delimiter is simply the character or text placed between the joined values. With TEXTJOIN, the first argument controls that delimiter, so you can change it without rebuilding the rest of the formula.

If you have a variable number of populated cells in a row, TEXTJOIN is often easier to maintain than writing a separate ampersand for every cell. For example, it can join a row of address parts while skipping empty fields. Still, confirm that ignoring empty cells suits the data: a blank may be meaningful, and omitting it can make two neighboring values appear to belong together.

Be careful with dates and numbers. A joined formula uses the stored value, which may not look like the formatted value in the source cell. A date can appear as a serial number in the combined text, and a number formatted to show leading zeros may lose those zeros. If exact display formatting matters, make the source value text in the required format before joining, or use a formula with TEXT for the specific number or date format. For identifiers such as account codes, storing them as text from the start is usually safer than treating them as quantities.

For a large table, convert the range to an Excel table using Insert > Table. Formulas entered in a table column usually fill through the column automatically, and the header makes the new field easier to identify. This is convenient for expanding data, but still verify the formula and check the values before removing source fields.

Use Ctrl+Z on Windows, or Command+Z on Mac, to undo a recent accidental edit. Undo is useful immediately after a mistaken paste or deletion, but it is not a substitute for a backup. Save a copy before making broad structural changes to a workbook.

Troubleshooting

The result shows the formula instead of the combined text. Check whether the destination cells are formatted as Text. Change the format to General from Home > Number Format, then re-enter the formula by selecting the cell, pressing F2, and pressing Enter. Also check that Show Formulas is not enabled; Ctrl+` on Windows toggles it. On some Mac keyboards the backtick key combination differs, so use the Formulas tab’s Show Formulas control if needed.

There is no space, or there are too many spaces. Confirm that the formula includes a quoted space between the ampersands. Then inspect the source cells for leading or trailing spaces. If the result contains double spaces because both the source and formula add spaces, remove the extra separator from one place. TEXTJOIN with its ignore-empty argument set to TRUE helps avoid separators for genuinely blank cells, but it does not remove spaces typed into nonblank cells.

The formula returns an error or an unexpected value. Verify that each cell reference points to the intended row and column, and that quotation marks and parentheses are balanced. If your Excel installation uses a different regional list separator, it may require semicolons instead of commas in functions; the formulas here use the standard comma syntax for the stated setup. Check whether a source cell itself contains an error, since joining that cell can carry the error into the result.

Some rows are missing results. Check whether the fill handle stopped early or whether there is a blank row in the adjacent column that prevented double-click autofill from reaching the bottom. Select the full destination range and use Ctrl+D on Windows or Command+D on Mac, or drag the fill handle to the actual last data row. Then inspect the last few records.

Deleting a source column breaks the combined column. The result is still a formula that references the deleted cells. Undo the deletion if possible, restore the source, and copy the combined results. Use Home > Paste > Values in the output column, verify the values, and only then remove the sources. If the workbook was saved and closed after deletion, recover an earlier version or backup if available.

Frequently Asked Questions

Will combining columns delete the original data?
No, not when you put the formula in a separate destination column. The source cells remain unchanged. Data may be lost if you overwrite a source or use Merge & Center on cells that already contain multiple values.

Can I combine three or more columns?
Yes. Use TEXTJOIN with a range covering the cells in that row, such as A2:C2, or link each cell with ampersands and separators. TEXTJOIN is usually more convenient when some cells may be blank. Check the order of the range, because the result follows that order.

How do I combine columns without a space between them?
Use an empty delimiter with TEXTJOIN, or join references with ampersands and no text between them. This is useful for codes that are meant to be continuous, but it can make ordinary words or names hard to read.

Can I delete the original columns after combining them?
Yes, after converting the output formulas to values and checking that the values are correct. If you delete the source columns while formulas still refer to them, the combined results may break. Keep a backup if those source fields may be needed later.

Does this work in Excel for Mac or Excel for the web?
The formulas and general process work in current Excel for Mac and Excel for the web. Ribbon labels and paste menus can differ slightly by platform. On Mac, use Command instead of Ctrl for common copy and undo shortcuts; Excel for the web provides the same basic formula entry and values-paste options through its ribbon.

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.