Revert Text to Columns in Excel: Undo or Rejoin Data

To revert Text to Columns in Excel, press Ctrl+Z immediately after splitting the data; on a Mac, press Command+Z. If you have already closed the workbook or cleared the undo history, Excel has no built-in reverse command, but you can often rebuild each original value by joining the split cells or restore an earlier copy of the workbook.

What Text to Columns Does

Text to Columns takes values in one column and separates them into multiple columns. It is commonly used to split full names, addresses, product codes, or imported data at a delimiter such as a comma, space, or tab. In Excel for Microsoft 365 on Windows, you can start the feature from Data > Text to Columns. The wizard offers Delimited and Fixed width options.

With Delimited, Excel looks for a chosen character or characters. For example, splitting North,West,Depot at commas produces three cells. With Fixed width, you indicate where the divisions should occur, which is useful for consistently positioned text such as a record with a code in characters 1–5 and a description after that.

The first output field stays in the original column, while later fields go into columns to its right. That means Text to Columns can replace existing contents in those destination cells. Excel normally warns you if the output area contains data, but the safest approach is to check the neighboring columns before running the wizard. The operation may also convert values: a string that looks like a date or number can become an actual date or number, and leading zeros may disappear.

Undo the Split Immediately

If the result is wrong or you simply want the original layout back, use Undo before doing anything else. On Windows, press Ctrl+Z or select the Undo button on the Quick Access Toolbar. On Mac, press Command+Z. In Excel for the web, use the Undo button or the applicable keyboard shortcut shown by your browser and Excel.

Undo reverses the Text to Columns action, including its changes to the selected data. If you have made several changes since the split, you may need to undo multiple actions, one at a time. Check the worksheet after each undo so you do not remove a later edit you wanted to keep. If the Undo button is unavailable, or the split is no longer listed in the undo history, move on to a recovery or reconstruction method.

Saving the workbook does not, by itself, mean that you should assume recovery is impossible. However, closing the workbook and reopening it generally removes the ordinary undo history for that editing session. For that reason, if you have just noticed an unwanted split, try Undo before closing the file or making many additional changes.

Why There Is No Reverse Text to Columns Command

Excel treats Text to Columns as an edit to worksheet cells, not as a reversible view setting. After the split, it does not retain a special record that says which cells belonged to one original string or which separator was used. Once the undo history is gone, Excel cannot reliably infer whether adjacent values such as Jordan and Lee were originally joined with a space, a comma, a tab, or something else.

This distinction matters when the split changed the data as well as its layout. For instance, the original text 00427 could be converted to the number 427. Joining the resulting cells cannot restore the missing zeros unless you know how many were present. Similarly, date recognition may change how a value is stored or displayed. Undo is the most dependable way to reverse the exact operation; rebuilding is a practical workaround, not a guaranteed recreation of the original input.

Join Split Cells Back into One Value

If the undo history is unavailable and the split values remain in neighboring cells, a formula can join them into a new cell. Suppose the three parts of a record are in B2:D2 and the original separator was a space. In E2, enter =TEXTJOIN(" ",TRUE,B2:D2). For the example values North, West, and Depot, the result is North West Depot. Change the quoted separator to match the original, such as a comma followed by a space: =TEXTJOIN(", ",TRUE,B2:D2).

TEXTJOIN is available in Microsoft 365 and Excel 2019 or later. The second argument controls how blanks are treated. TRUE skips empty cells, which is handy when some rows contain fewer parts. But skipping blanks can change the structure: if an empty field represented a missing value between two commas, ignoring it will not preserve that empty position. Use FALSE when you need blank cells represented by the chosen delimiter, and inspect the result for leading, trailing, or repeated separators.

After checking the formula results, you can copy them and use Home > Paste > Paste Values to replace the formulas with their displayed text. Do this in a separate output column first. That leaves the split data available for comparison until you are confident the joined values are correct. If the original data occupied one column and you want to restore that layout, copy the finished values into the intended column only after checking that you will not overwrite useful information.

Recover an Earlier Version or Copy

If joining cells would not restore the original values, look for an earlier copy of the workbook. For a file stored in OneDrive or SharePoint, Excel’s version history may let you open or restore a previous version. In Excel for Windows, look under File > Info > Version History when that option is available. Availability and the exact options depend on where the file is stored and your organization’s settings.

For a local file, check any manual backup, a duplicate workbook, or an organization-managed backup. Excel may also offer recovery for an unsaved workbook through File > Info > Manage Workbook > Recover Unsaved Workbooks, but this is not a general way to reverse a completed operation in a saved file. Recovery options vary by version and settings, so do not count on an automatic recovery copy being available. Before restoring an older version, consider saving the current workbook under a different name so you can compare both.

Common Problems When Reconstructing Data

Choosing the wrong separator: A space-based join will not reproduce values originally separated by a comma or hyphen. Check an untouched example, an import specification, or another copy of the source data.
Missing or extra spaces: Some Text to Columns settings can leave spaces around the split fields. A separator in TEXTJOIN adds its own characters, so inspect the output instead of assuming it matches the original exactly.
Empty fields: A row with a blank middle field can be altered if the formula skips blanks. Decide whether that blank is meaningful before using TEXTJOIN’s ignore-empty option.
Overwritten destination cells: If the split replaced cells to the right, joining the visible fragments cannot recover the former contents of those cells. Use undo, version history, or a backup to restore overwritten material.
Changed numbers and dates: If Excel converted text during the split, joining cells may preserve the displayed result but not the original text formatting or leading zeros. Recover the source where exact text matters.

Prevent the Same Problem Next Time

Before using Text to Columns, make a copy of the source column or duplicate the worksheet. Another option is to save a separate copy of the workbook first. These precautions are especially useful when the source includes identifiers, dates, postal codes, or values with leading zeros, because automatic conversion can alter how they are stored.

Also check the destination area to the right of the selected column. If it contains information, move the output to an empty area or insert blank columns before running the wizard. In the wizard, review the delimiter or fixed-width boundaries and the data preview. If a field must remain text, select that field in the preview and choose Text as its column data format before completing the operation. This can help preserve codes that Excel might otherwise interpret as numbers.

For repeatable work, consider importing the source into a separate worksheet and keeping the untouched import as a reference. That gives you a clean recovery point without relying on the undo stack. If you use a formula to combine fields, retain the original split columns until you have verified several rows, including records with blanks and unusual punctuation.

Alternatives to Reversing the Split

If your goal is only to display a single combined value, you may not need to remove the split columns. A TEXTJOIN formula in a new column can create the combined result while leaving the separate fields available for sorting, filtering, or analysis. This is often preferable when the parts have independent meaning, such as city, state, and postal code.

When the original source is available, reimporting it may be cleaner than reconstructing it. For recurring imports, Power Query can split columns during a transformation and retain the steps used to shape the data. You can adjust or remove a transformation in the query rather than manually undoing worksheet edits. Power Query is suited to repeatable data preparation; for a one-time split, the Text to Columns wizard may be quicker.

Frequently Asked Questions

Can I reverse Text to Columns after saving the workbook?
Usually, try Ctrl+Z first if the workbook is still open and the action remains in the undo history. If it does not, use version history or a backup, or join the split cells if the original text can be reconstructed.

Does Excel have an Unsplit Columns button?
No. Excel has no general command that reverses Text to Columns after the undo history is gone. Use Undo, restore an earlier copy, or rebuild the values with a formula or another suitable method.

How do I combine columns with commas again?
With the split fields in B2:D2, enter =TEXTJOIN(",",TRUE,B2:D2) in another cell. This joins nonblank cells with commas; use a different separator if the original included spaces or other characters.

Can I recover cells that Text to Columns overwrote?
Not by joining the split results. Try Undo or restore a version or backup from before the split. If the overwritten cells were not saved anywhere, Excel may not have enough information to recreate them.

Why did my leading zeros disappear?
Excel may have interpreted a split field as a number, and numbers do not retain typed leading zeros as part of their value. Undo or restore the original text for an exact recovery; for future splits, set the relevant field’s format to Text in the wizard.

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.