Opposite of Text to Columns in Excel: Combine Cells

The opposite of Text to Columns in Excel is combining values from multiple columns into one cell, usually with a separator such as a space or comma. In Microsoft 365 on Windows, TEXTJOIN is often the simplest option because it can add a delimiter and skip empty cells.

What “opposite” means in Excel

Text to Columns takes text in a cell and separates it into multiple columns, using a delimiter such as a comma or space, or positions you specify with fixed-width breaks. Combining columns reverses that broad direction: it brings several fields on the same row together into a single text value. For example, first name in one column and last name in another can become a full name in one cell.

Excel does not provide a single command called “Columns to Text” that automatically undoes every Text to Columns operation. The right way to recombine data depends on what the columns represent and what you want between the values. A space might suit names, a comma and space might suit a city-and-region display, and no separator might suit parts of a code.

It is also not always a perfect, lossless reversal. If the original text contained the same delimiter used for splitting, or had meaningful spacing, quoting, or empty fields, simply joining the resulting cells may not reproduce the original text exactly. The columns may no longer contain enough information to reconstruct those details.

Combine columns with TEXTJOIN

For a row-by-row combination, enter a formula in an empty column. With first name in A2, last name in B2, and a middle name in C2, use a space as the separator. The formula assumes those fields are in A2:C2 and the result will go in another cell on row 2:

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

The result joins nonempty cells in order, placing a space between the values. With A2 containing Maya, B2 blank, and C2 containing Chen, the result is Maya Chen. The second argument, TRUE, tells Excel to ignore empty cells, which avoids a doubled separator caused by a blank field.

To combine a street, city, and state with comma-space separators, the layout could be street in A2, city in B2, and state in C2. This formula places the finished address in a separate cell:

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

If those cells contain 14 Oak Street, Boston, and MA, the result is 14 Oak Street, Boston, MA. After entering the formula, press Enter. To apply it to other rows, drag the fill handle—the small square at the lower-right corner of the selected cell—down the column. Excel adjusts the row references as it fills.

Other ways to join values

TEXTJOIN is useful when you want a consistent delimiter and want to control how blanks are handled. For simple combinations, the ampersand operator is another straightforward choice. With first name in A2 and last name in B2, this formula joins them with one space:

=A2&" "&B2

This returns Maya Chen if A2 is Maya and B2 is Chen. Unlike the earlier TEXTJOIN example, this expression inserts the space whether or not either cell is blank. If A2 is empty and B2 contains Chen, the result begins with a space. You can use this approach when the fields are predictable and you want to specify every separator yourself.

CONCAT joins text but does not insert a delimiter automatically. With the parts of a product code in A2:C2, this formula puts them together without spaces or punctuation:

=CONCAT(A2:C2)

If the cells contain AB, 04, and X, the result is AB04X. To add punctuation with CONCAT, include it as an additional text value in the formula, or use ampersands. For most users who need a separator across a range, TEXTJOIN makes the intent easier to see.

Choose a separator and handle blanks

The delimiter is part of the output, so choose it based on how the combined text will be read or used. Common options include:

A space for full names or words that belong together.
A comma followed by a space for readable lists or addresses.
A hyphen for codes whose parts are conventionally separated.
An empty string for components that should touch, such as some identifiers.

Blank cells deserve attention. If a middle name is optional, ignoring empty cells with TEXTJOIN can produce a clean name. But if a blank field has meaning—for example, it marks a missing item in a fixed-format record—skipping it may conceal that gap. A formula that joins A2:C2 with hyphens and ignores blanks could turn values in A2 and C2 into a single hyphen-separated pair, even though B2 was missing. Decide whether blanks should disappear or remain represented before choosing the method.

Also consider whether a delimiter already appears inside the values. Joining city names with commas is readable, but a later process that splits the result at every comma may be ambiguous if a field itself contains a comma. If the combined text is meant for data exchange rather than display, check the receiving system’s rules for quoting, escaping, and separators.

Fill down, copy, and make the result permanent

A formula-based combination updates when its source cells change. That is helpful when the joined value is a live display, but it may not be what you want for a final export or a fixed list. If you need a static result, first make sure the formulas show the intended text, then copy the result cells and use Paste Special > Values to replace formulas with their current displayed values. Keep a copy of the original columns until you have checked the output.

For a small table, enter the formula in the first data row and fill it down. For a larger table formatted as an Excel Table, entering the formula in a new table column generally fills the calculated column for the other table rows as well. Check the first, middle, and last rows after filling: an unexpected blank, extra space, or row mismatch can be easier to catch before you export or delete anything.

Do not overwrite source columns while experimenting. Put the combined result in an unused column, confirm it, and only then decide whether to retain or remove the originals. This is especially important when the original text was split with Text to Columns, because reconstructing the source may not be possible if information was discarded or altered.

Use Power Query for repeatable data preparation

If you regularly receive files with the same columns and need to combine them as part of a repeatable cleanup, Power Query can merge columns. In Excel for Microsoft 365 on Windows, select a cell in the source data and choose Data > From Table/Range. If the data is not already an Excel table, Excel will prompt you to create one. In the Power Query Editor, select the columns to combine, then choose Transform > Merge Columns. Choose a separator and provide a new column name in the dialog.

When the transformation is ready, use Home > Close & Load to return the result to Excel. The merge becomes part of the query, so refreshing the query can apply the same steps to updated source data. This is different from a cell formula: the result is produced through the query’s transformation steps, rather than recalculating directly in each worksheet cell.

Power Query is useful when combining columns is one step in a larger process, such as importing, cleaning, and reshaping recurring files. For a one-off combination in a worksheet, a formula is usually quicker. Power Query availability and interface details can vary across Excel editions and platforms; the menu path above describes Microsoft 365 for Windows.

Common problems and how to avoid them

A common surprise is an extra space or punctuation mark. With ampersands, the separator is added exactly where the formula places it, even when a neighboring cell is blank. With TEXTJOIN, setting the ignore-empty argument to TRUE skips blank cells, but cells containing a formula that returns an empty string may require checking in the particular data layout. Test representative rows, especially rows with optional fields.

Another issue is joining numbers that have special formatting. A cell may display a date, currency amount, or number with leading zeros, while a concatenation formula uses the underlying value rather than preserving every display format. For instance, a postal code stored as a number may lose leading zeros before it is joined. Store identifiers such as postal codes as text, or prepare the value in the required format before combining it.

Long results can also hit Excel’s cell text limit of 32,767 characters. That limit is rarely a concern for names or ordinary addresses, but it matters when combining long notes or large text fields. Finally, if you plan to split the joined result again, make sure the separator cannot be confused with characters inside the data, or use a format designed to preserve field boundaries.

Which method should you choose?

Choose TEXTJOIN for a row of fields with a delimiter, particularly when blank cells should be skipped. Choose & when joining a few known cells with explicitly placed text between them. Choose CONCAT when you want to append values without a separator. Choose Power Query when the merge is part of a repeatable import or cleanup process.

Before you begin, decide whether the goal is a readable label, a fixed text value, or data that another program will process. A display name can prioritize readability; an identifier or export field may require exact punctuation, preserved zeros, and explicit treatment of missing values. The most suitable “opposite” depends on that purpose, not just on reversing the direction of a menu command.

Frequently Asked Questions

Is there a reverse Text to Columns button in Excel?
No. Excel does not have a universal one-click inverse command. Combine the relevant cells with TEXTJOIN, CONCAT, or ampersands, or merge columns in Power Query for a repeatable transformation.

What formula combines columns with spaces?
Use TEXTJOIN(" ",TRUE,A2:C2) for values in A2:C2 when you want spaces between nonblank entries. Adjust the range to match your fields and place the formula in an empty cell on the same row.

How do I combine cells without a space?
Use CONCAT or join the cells directly with ampersands and no separator. This is appropriate for adjoining code parts, but check that removing the separator will not make the result hard to interpret.

Will combining columns restore the original text exactly?
Not necessarily. It works only if the original separator and the treatment of spaces, blanks, and embedded delimiters are known and the split did not discard information. Review the output rather than assuming it is an exact reversal.

How do I keep the combined text instead of the formula?
Copy the formula results, then use Paste Special > Values. This replaces the formulas with their current displayed values; retain the original columns until you have verified the pasted text.

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.