Excel Text to Columns: How to Undo and Restore Data

How-to basics · Updated November 21, 2026

To undo Text to Columns in Excel for Microsoft 365 on Windows, press Ctrl+Z immediately after running it; on a Mac, press Command+Z. If you have made other changes since, undo them one at a time until the Text to Columns operation is reversed, or use a backup or version history if the undo option is no longer available.

Undo Text to Columns step by step

Text to Columns is an undoable worksheet action in the usual case. The fastest way to reverse it is the keyboard shortcut. You can also click the Undo arrow on the Quick Access Toolbar in Excel for Windows. In Excel for Mac, use Command+Z or choose Edit > Undo.

  1. Go back to the workbook where you ran the operation.
  2. Press Ctrl+Z on Windows or Command+Z on Mac once.
  3. Check the affected cells. If the split or conversion has not been reversed, look at the Undo button or undo list to see the most recent actions.
  4. If you made later edits, undo them in reverse order until Excel reaches Text to Columns. Stop when the original data returns.

On Windows, Ctrl+Y can redo an action that you just undid. Redo is useful if you went one step too far, but a new edit after undoing can replace the redo history. If you are uncertain which actions will be rolled back, save a separate copy of the current workbook before continuing.

What Text to Columns changes

The command is on the Data > Text to Columns tab in Excel for Microsoft 365 on Windows. It takes values from a selected column and can divide them into multiple columns, using either delimiters or fixed character positions. A delimiter is a character such as a comma, tab, semicolon, or space. Fixed width lets you mark where one field ends and the next begins.

The operation can change more than the visible arrangement. For example, when the wizard treats a field as a date or number, Excel may convert the stored value. A code such as 00427 can lose its leading zeros if Excel interprets it as a number, and text that resembles a date can become a date value. The wizard also lets you designate columns as Text, Date, or General, so the choices made there affect the result.

Suppose A2 contains Jordan Lee,Seattle,WA. Splitting on commas can put Jordan Lee, Seattle, and WA into separate cells across the row. Undo restores the original contents and arrangement, provided that the operation is still in Excel’s undo history. It is not a special “merge columns” command; it reverses the most recent worksheet action.

How to tell whether Undo is still available

Check the Undo button or open its drop-down list. If Text to Columns appears among the recent actions, you can undo back to that point. The list can also show why a single Ctrl+Z may not seem to work: Excel reverses the latest action first, so a formatting change, cell entry, or other operation you performed afterward is undone before the split.

Undo is generally available while the workbook remains open and the operation remains in the current undo history. Saving the file by itself does not necessarily remove the ability to undo. However, closing the workbook ends that working history, and certain operations can clear it. If the workbook has been closed and reopened, or the Undo control is disabled, Ctrl+Z cannot retrieve the earlier state from the saved file.

Be deliberate when undoing several actions. Excel does not skip over intervening work to reverse only Text to Columns. If you undo five later edits to reach the split operation, those five edits are rolled back too. You may be able to redo them afterward, but a safer approach is to preserve a copy before a long undo sequence.

Windows, Mac, and Excel for the web

For Excel for Microsoft 365 on Windows, use Ctrl+Z and the Data > Text to Columns command. On Mac, Command+Z is the undo shortcut; the command is available from the Data tab, though the ribbon layout can look different from Windows. The Text to Columns wizard may also present its controls differently depending on the Excel build, but the key choice remains whether to split by a delimiter or fixed width.

In Excel for the web, use the Undo control in the toolbar or Ctrl+Z in a Windows browser. On a Mac, use Command+Z. Undo applies to actions in the current editing session; it is not a replacement for a saved backup or version history. If the workbook is stored in OneDrive or SharePoint, version history may provide a way to recover an earlier saved version, subject to the file’s storage and retention settings.

If Ctrl+Z cannot restore the original data

First, avoid making more edits to the affected range. If the workbook is still open, inspect the Undo list carefully. If the file was closed, look for an earlier saved copy, a backup, or a cloud version. For a workbook saved to OneDrive or SharePoint, Excel for Windows may show File > Info > Version History. In Excel for the web, look for Version History through the file interface. Availability and the exact route can depend on where the workbook is stored and your organization’s settings.

Before restoring an older version, make a copy of the current file if it contains other useful edits. Restoring a version can replace the workbook state, not just repair the cells affected by Text to Columns. Compare timestamps and, where possible, open an earlier version to check that it contains the data you need before choosing to restore it.

If no earlier version exists, Excel cannot automatically infer the original text from a split result in every case. It may be possible to rebuild the value from the resulting columns, but the result is only exact when you know the original delimiter and how blanks, spaces, quotes, and embedded delimiters were handled. For example, splitting a comma-separated address does not tell you whether a comma inside a quoted street name was part of the original field or a separator unless the source and settings are known.

Recombine split columns when Undo is unavailable

If the original value was divided into two columns with a comma between them, and the pieces are now in A2 and B2, enter this formula in another cell:

With the first piece in A2 and the second piece in B2, =A2&CHAR(44)&B2 joins them with a comma. If A2 contains North and B2 contains West, the result is North,West.

For more than two columns, extend the same idea by joining each cell with the required separator. Choose an empty destination range so you do not overwrite the remaining split data, and check the output before replacing anything. A formula rebuilds text; it does not restore the original cell’s exact formatting, formulas, data types, or prior selection. It also will not recreate a delimiter that was discarded or distinguish an empty field from a missing value unless you know how the source was structured.

If the columns contain numbers or dates that were converted during the split, joining them may produce text that looks different from the original entry. For instance, a numeric value that lost leading zeros cannot supply those zeros automatically. You may need to know the required width or original formatting to reconstruct a code accurately.

Common problems and misconceptions

  • “I pressed Ctrl+Z and the split did not change.” The first press may have undone a later action. Check the Undo list and proceed carefully.
  • “Saving made Undo impossible.” Saving alone does not always clear the undo history. Closing the workbook or performing an action that clears history is a more likely reason it is unavailable.
  • “Text to Columns only changes formatting.” It can split cell contents and convert values, depending on the wizard’s settings. A changed date or lost leading zero is a data-conversion issue, not merely a display-format change.
  • “I can put the pieces back and get the exact original.” Sometimes, but not always. Reconstruction depends on the original separators, empty fields, and conversion choices. A formula cannot recover information that is no longer present.

Also confirm that you are working in the right workbook and sheet. If several files are open, an undo command affects the active workbook, not necessarily the file you intended. Before undoing a long sequence, inspect the workbook title and the recent-action list.

Prevent accidental splits next time

Text to Columns can affect a wide range of cells, so preserve the source before using it on data you cannot easily replace. Copy the original column to a new worksheet or workbook, or save a separate copy of the file. This is especially useful for imported records, product codes, dates, and identifiers with leading zeros.

  • Select only the source cells you intend to split, and inspect the wizard’s data preview.
  • Choose the correct delimiter or fixed-width positions; a space delimiter, for example, can split a full name into more fields than intended.
  • Set identifier columns to Text when preserving leading zeros or exact character sequences matters.
  • Check the destination and the cells beside the source so you know where the output will go.
  • Review dates, numbers, blanks, and sample rows after the operation before continuing with other edits.

These checks do not replace Undo, but they reduce the chance that a quick split will create a harder recovery problem. For repeated imports, a saved copy of the original data is often more dependable than relying on the undo history.

Frequently Asked Questions

Can I undo Text to Columns after saving the workbook?

Often, yes, if the workbook is still open and Text to Columns remains in the undo history. Saving does not automatically mean the action is irreversible. If you closed and reopened the workbook, use a backup or version history instead.

How do I undo Text to Columns on a Mac?

Press Command+Z immediately after the operation. If you made other edits afterward, undo them one at a time until the split is reversed, taking care not to remove changes you want to keep.

Can I reverse Text to Columns after closing Excel?

Usually not with Ctrl+Z or Command+Z, because closing the workbook ends that undo history. Check for an earlier file copy or a OneDrive or SharePoint version. If neither exists, you may need to reconstruct the data from the split columns.

Does Text to Columns change the original column?

It uses the selected column as its source and places the split results across columns. The result can change cell contents or convert values depending on the wizard settings, so check the destination and nearby cells and keep a copy of important source data.

Can I merge the split columns back without undoing?

Yes, you can join the pieces with a formula or copy and paste, but that rebuilds text rather than restoring the original worksheet state. It may not recover lost zeros, original formatting, or ambiguous separators. Use Undo or an earlier version when an exact restoration matters.

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.