Reverse Text to Columns in Excel: How to Recombine Data

How-to basics · Updated November 18, 2026

Yes. To reverse Excel’s Text to Columns operation, combine the resulting cells with a formula such as =TEXTJOIN(" ",TRUE,A2:C2)—assuming the split text is in A2:C2 and you want spaces between the pieces. Choose the delimiter that belongs between your values; if you do not know what the original delimiter was, Excel cannot always rebuild the original text exactly.

What “reverse Text to Columns” means

Text to Columns takes text in one cell and separates it into multiple columns, usually at a delimiter such as a comma, space, or tab, or according to fixed character positions. Reversing that process generally means joining the resulting cells back into one cell. For example, after splitting North|West at the vertical bar, you might want one cell containing North|West again.

Excel does not have a single Reverse Text to Columns button. Instead, you choose a joining method and specify how the pieces should be separated. That choice matters: a space is appropriate between a first and last name, while a comma and space may be appropriate between city and state. The values alone usually do not tell Excel which separator to restore.

Also, “reverse” can mean reversing the order of characters—for example, changing Excel to lecxE. That is a different task. The methods here recombine values from separate cells into one text value; they do not reverse the letters within a value.

Use TEXTJOIN for a flexible formula

For most worksheets, TEXTJOIN is the clearest way to recombine a range. It takes a delimiter, a setting that controls whether empty cells are ignored, and the text or range to join. It is available in Microsoft 365 and newer perpetual versions such as Excel 2019 and Excel 2021.

With the pieces in A2:C2 and a space required between nonblank pieces, enter this formula in D2:

=TEXTJOIN(" ",TRUE,A2:C2)

If A2 contains Maya, B2 is blank, and C2 contains Chen, the result is Maya Chen. The TRUE argument tells Excel to ignore empty cells, so the blank middle cell does not create an extra separator. To combine a whole row of split data, adjust the range—for example, use A2:F2 if six columns contain the pieces. Fill the formula down for other records.

The delimiter is the first argument, so change it to match the desired output. With values in A2:B2 and a vertical bar between them, use =TEXTJOIN("|",TRUE,A2:B2). If A2 is North and B2 is West, the result is North|West. For a comma followed by a space, use =TEXTJOIN(", ",TRUE,A2:B2).

When empty cells have a meaningful place in the output, set the second argument to FALSE. With A2:C2 containing Red, a blank, and Blue, respectively, =TEXTJOIN("-",FALSE,A2:C2) returns Red--Blue. That preserves a separator for the empty middle position. Decide whether blanks should disappear or retain their position before filling the formula down.

Use the ampersand for a simple join

The ampersand operator joins text without requiring a special function, and it works in older Excel versions too. With a first name in A2, a last name in B2, and a space between them, enter this in C2:

=A2&" "&B2

If A2 is Maya and B2 is Chen, the result is Maya Chen. For three columns in A2:C2 separated by spaces, use =A2&" "&B2&" "&C2. This method is easy to understand when there are only a few columns and you want precise control over each separator.

The trade-off is that a blank cell can leave an unwanted space or punctuation mark. With values in A2:C2 and possible blanks between them, this formula removes extra spaces at the start and end and reduces repeated spaces: =TRIM(A2&" "&B2&" "&C2). TRIM does not remove every kind of whitespace, and it can also reduce intentional repeated spaces in the text. For many columns or irregular blanks, TEXTJOIN with its ignore-empty option is usually easier to manage.

Choose the right separator and preserve the data

The most important decision is not the formula; it is what the separator should be. Text to Columns often discards the original delimiter when it distributes the pieces into separate cells. If the source was split at a comma, that does not automatically mean a comma should appear in the recombined result: the original might have been a comma, a comma and a space, or a delimiter that was removed along with surrounding spaces.

Before building a formula, check the original source or a few representative records. Consider whether separators belong between every pair of fields, whether spaces should appear around punctuation, and whether blank fields should be skipped. For instance, an address split into street, city, and postal code may need different punctuation from a list of tags split at semicolons.

  • Use a space for ordinary words, such as first and last names.
  • Use comma-space for readable lists or values such as city and region, if that matches the intended format.
  • Use the exact character used in a machine-readable string, such as a pipe or semicolon, when another system expects it.
  • Check whether the source had spaces around its delimiter; TEXTJOIN adds only the characters you specify.

Be especially careful with values that contain the delimiter themselves. If a field originally contained a comma and the data was split at every comma, a simple join cannot tell which comma was part of the field and which one separated fields. Quoting rules, escaped delimiters, or a more carefully designed import process may be needed to preserve that distinction.

Fill the formula down and keep the result

After entering a formula in the first result row, use the fill handle at the lower-right corner of the selected cell to copy it into later rows. Excel adjusts relative references automatically: a formula referring to A2:C2 becomes one referring to A3:C3 in the next row. If the source is formatted as an Excel table, a formula entered in a table column can fill down through that calculated column automatically.

Formulas keep updating when the source cells change. That is useful if the separated fields are still being edited, but it may not be what you want for a finished export. To replace formulas with fixed text, copy the result cells and choose Home > Paste > Values. The pasted values no longer depend on the original columns. Keep a copy of the source columns until you have checked the output, especially if the split was done in place.

If you accidentally split data and have not made other changes, Ctrl+Z on Windows can undo the last operation. On Mac, use Command+Z. Undo is not a substitute for a backup once other edits have been made or the workbook has been closed. For important workbooks, keep the source data on a separate sheet or save a copy before changing its layout.

Recombine columns with Power Query

Power Query is useful when the same cleanup needs to be repeated, or when the source contains many rows. In Excel for Microsoft 365 on Windows, first turn the data into a table or select a cell in an existing table. Choose Data > From Table/Range to open the Power Query Editor. Select the columns to combine, then choose Transform > Merge Columns, choose a separator, and provide a new column name. Use Home > Close & Load to return the result to Excel.

Power Query keeps the transformation as a repeatable set of steps. If the source table later receives more rows, you can refresh the query rather than rebuilding formulas for each new record. It is a good fit for recurring imports, but it may be more setup than needed for a one-time, two-column join. Menu labels or availability can differ between Excel platforms and builds; Excel for the web does not expose every Power Query editing feature available in the Windows desktop app.

As with a formula, merging in Power Query requires a separator choice. It does not infer lost punctuation or recover details that were removed during the original split. To protect source data, load the result to a separate location rather than overwriting the only copy of the input.

When Flash Fill is a better fit

Flash Fill can create a combined text value from a pattern you demonstrate. Suppose A2 contains a first name and B2 a last name. Type the desired full name in C2, then use Data > Flash Fill. On Windows, Ctrl+E is the Flash Fill shortcut. Excel looks for a pattern in the neighboring data and fills the rest of the column where it can recognize one.

Flash Fill produces values rather than formulas, which can be convenient for a one-off cleanup. It is not as dependable as an explicit formula when the pattern varies, blanks are common, or a separator must be exact. Review the results, particularly rows with middle names, suffixes, punctuation, or missing fields. If the source changes later, Flash Fill results do not automatically recalculate.

Common problems and limits

  • Extra spaces: A formula that inserts a space for every source column may create double spaces when some cells are blank. Use TEXTJOIN with TRUE to ignore empty cells, or consider TRIM for a simple fixed arrangement.
  • Missing punctuation: Joining with a space does not restore a comma, slash, or other original delimiter. Specify the required separator explicitly.
  • Values that look like numbers or dates: A join produces text. The display may differ from the original cell formatting, especially for dates, leading zeros, or numbers with custom formats. If the exact displayed form matters, format or convert the values deliberately before joining.
  • Lost information: If Text to Columns removed a delimiter or split a field ambiguously, combining the resulting cells cannot reliably recover the original characters. Retain the unsplit source whenever exact restoration matters.
  • Formula shown instead of result: Check that the cell is not formatted as Text, and confirm that Show Formulas is not enabled. Changing a text-formatted cell to General and re-entering the formula can help.

A useful distinction is that Excel can join the current cell contents, but it cannot know what those cells used to represent. If the source text was AB-123 and a split separated it into AB and 123, joining with a hyphen reconstructs that example. If some records used a different separator or contained the separator inside a field, a universal formula may not reproduce every original string.

Frequently Asked Questions

Can I reverse Text to Columns without a formula?
You can use Power Query’s Merge Columns command or Flash Fill for a suitable pattern. For a quick, transparent result, a formula is often easiest; Power Query is more useful for repeatable imports, while Flash Fill creates static values.

What formula combines columns in Excel?
For a range with a chosen separator, TEXTJOIN is usually the most flexible option. For example, with the pieces in A2:C2 and spaces between nonblank values, =TEXTJOIN(" ",TRUE,A2:C2) combines them and ignores empty cells.

Can Excel restore the exact original text?
Only if you know the original separator and the split did not discard or ambiguously divide information. Text to Columns does not retain a record of every removed delimiter in the resulting cells, so exact reconstruction is not guaranteed.

How do I combine columns but skip blank cells?
Use TEXTJOIN and set its second argument to TRUE. For values in A2:C2 with spaces between them, =TEXTJOIN(" ",TRUE,A2:C2) skips empty cells instead of inserting separators for them.

Does Text to Columns have a reverse button?
No. Excel has no dedicated reverse command for this operation. You recreate a single text value by joining the columns with a formula, Power Query, or Flash Fill, depending on how often you need to do it and how consistent the data is.

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.