How to Combine Columns Into One in Excel

To combine three columns into one in Excel, click an empty cell, type =A2&" "&B2&" "&C2, and press Enter. Excel joins the three cells with a space between each, and you then drag the fill handle down to repeat it for every row.

These steps work in Excel for Microsoft 365, Excel 2024, 2021, 2019, 2016, and 2013 on Windows, and in current Excel for Mac. The & formula, CONCATENATE, and Flash Fill also work in Excel 2013. CONCAT and TEXTJOIN need Excel 2019 or later or a Microsoft 365 subscription, and TOCOL and VSTACK need Microsoft 365 or Excel 2024.

Microsoft documents each method: combining text from two or more cells, the CONCAT and TEXTJOIN functions, and Flash Fill.

Which Method Should You Use?

“Combine columns” can mean two different jobs. Most people want to join the text across each row, so a first name, middle name, and last name end up in one cell. Others want to stack three columns on top of each other in one long column. Pick the method that matches your job and your Excel version:

You want to Best method Works in
Join each row with a space or comma & formula Every version
Join each row and skip blank cells TEXTJOIN Excel 2019 or later, Microsoft 365
Join each row without writing a formula Flash Fill Excel 2013 or later
Join columns in a large table you refresh often Power Query Excel 2016 or later for Windows, Microsoft 365
Stack three columns into one long column TOCOL or VSTACK Microsoft 365, Excel 2024

The examples below assume your data starts in row 2, with headers in row 1 and the three columns in A, B, and C. Change the letters and row numbers to match your sheet.

How to Combine Three Columns With the & Symbol

The ampersand (&) is Excel’s joining operator. It works in every version, including Excel 2013, Excel for the web, and Excel for Mac.

  1. Click the first empty cell in the column where you want the combined text, such as D2.
  2. Type =A2&" "&B2&" "&C2. Each " " is a space inside quotation marks, which Excel places between the values.
  3. Press Enter. D2 now shows the three values joined, such as Mary Ann Smith.
  4. Click D2 again and drag the small square in its bottom-right corner, called the fill handle, down to your last row. You can also double-click the fill handle to fill down to the end of the data.
Excel sheet with columns A to C combined in column D and the & formula in the formula bar
The filled column D shows the combined text for every row.

Each row now shows its three values joined with spaces. To build your own, type =, select a cell, then use & with a space in quotation marks before the next cell. If the combined text arrives in all caps, wrap it in PROPER to capitalize each word in Excel before pasting the values.

No empty column next to your data? Add a column in Excel first so the combined text has its own space.

Change the Separator

Whatever you put inside the quotation marks appears between the values:

Separator Formula Sample result
Space =A2&" "&B2&" "&C2 Austin TX 78701
Comma and space =A2&", "&B2&", "&C2 Austin, TX, 78701
Dash =A2&" - "&B2&" - "&C2 Austin – TX – 78701
None =A2&B2&C2 AustinTX78701
Line break =A2&CHAR(10)&B2&CHAR(10)&C2 Three lines in one cell

For the line break version, select the cells and click Home > Wrap Text, or the break won’t show.

Join a Whole Column at Once in Newer Versions

In Excel for Microsoft 365, Excel 2024, or Excel 2021, you can type the formula once and let it fill the column by itself. Click D2 and type =A2:A100&" "&B2:B100&" "&C2:C100. The results spill down into the cells below. If you see a #SPILL! error, something is in the way. Clear the cells under D2 and the results appear.

Keep Dates and Numbers Formatted

Dates and numbers lose their formatting when you join them, so a date can show up as a number such as 46000. Wrap that cell in the TEXT function to keep the format you want, for example =A2&" "&TEXT(B2,"mm/dd/yyyy") for a date or =A2&" "&TEXT(C2,"$#,##0.00") for a price.

The same TEXT trick fixes dates that look wrong when you merge Excel data into Word with a mail merge.

To go the other way and separate text into several columns, split a cell in Excel.

How to Combine Columns With CONCAT

  1. Click the cell where you want the result, such as D2.
  2. Type =CONCAT(A2," ",B2," ",C2).
  3. Press Enter, then drag the fill handle down.

CONCAT combines text from multiple ranges or strings, using commas to separate each item and quotation marks for spaces or other text. CONCAT doesn’t add separators on its own, so =CONCAT(A2:C2) runs the values together with nothing between them. It replaces the older CONCATENATE function, which still works for compatibility. In Excel 2013 or a standalone copy of Excel 2016, type =CONCATENATE(A2," ",B2," ",C2) instead. CONCATENATE accepts single cells but not ranges such as A2:C2.

How to Combine Columns With TEXTJOIN

  1. Click D2.
  2. Type =TEXTJOIN(" ",TRUE,A2:C2).
  3. Press Enter, then drag the fill handle down.
Excel TEXTJOIN formula joining three name columns and skipping a blank middle name
TEXTJOIN with TRUE skips the blank middle name, so no double space appears.

The first part is the separator, TRUE tells Excel to skip empty cells, and the range is the cells to join. This avoids extra separators when a cell is blank. That matters for lists where some people have no middle name: the & formula would give “Mary Smith” with two spaces, while TEXTJOIN gives “Mary Smith.”

TEXTJOIN can also join a single column into one cell. For example, =TEXTJOIN(", ",TRUE,A2:A20) turns a column of names into one comma-separated list.

CONCAT and TEXTJOIN are available on Windows or Mac with Office 2019 or later, or with a Microsoft 365 subscription. TEXTJOIN accepts up to 252 text arguments and CONCAT up to 253. If the result would be longer than 32,767 characters, the limit for one cell, both return a #VALUE! error. In older versions, use the & formula instead.

More ways to combine columns in Excel
Illustration: more ways to combine columns in Excel.

How to Combine Columns Without a Formula (Flash Fill)

Flash Fill copies a pattern you type once. It arrived in Excel 2013, and you can use Flash Fill in Excel for splitting and reformatting text too.

  1. Type the combined text for the first row yourself, such as Mary Ann Smith in D2, and press Enter.
  2. Start typing the next row in D3. Excel shows a gray preview of the rest of the column.
  3. Press Enter to accept it.

The column fills in with plain text, not formulas. If no preview appears, you can run it from Data > Flash Fill or press Ctrl+E. If neither works in Excel for Windows, click File > Options > Advanced and check Automatically Flash Fill under Editing options.

Check the results before you rely on them. Flash Fill guesses from your example, so rows with a blank cell or an extra word can come out wrong. Type a second example in the next row and press Ctrl+E again to give it a clearer pattern. Flash Fill results don’t update if you change the original columns later.

How to Combine Columns With Power Query

Power Query suits large tables or data you import again each week, because one refresh repeats the whole job. It’s built into Excel 2016 and later for Windows and into Excel for Microsoft 365.

  1. Click any cell in your data and press Ctrl+T to make it a table. Confirm My table has headers and click OK.
  2. Click Data > From Table/Range. The Power Query Editor opens.
  3. Click the first column header, then hold Ctrl and click the other two in the order you want them joined.
  4. Click Add Column > Merge Columns. Choose a separator, such as Space or Comma, type a name for the new column, and click OK.
Power Query Merge Columns dialog with Space separator and a new column name
Add Column > Merge Columns keeps your original columns.
  1. Click Home > Close & Load. Excel puts the result on a new sheet as a table.

Using Add Column keeps the original columns. The Merge Columns button on the Transform tab replaces them, as Microsoft’s Power Query merge columns article explains. When your source data changes, click Data > Refresh All to update the result.

How to Stack Three Columns Into One Column

If you want the values from A, B, and C listed one after another in a single column, use TOCOL or VSTACK in Microsoft 365 or Excel 2024:

  • =VSTACK(A2:A10,B2:B10,C2:C10) lists all of column A, then all of B, then all of C.
  • =TOCOL(A2:C10,1,TRUE) does the same and skips blank cells. The 1 means ignore blanks, and TRUE means read down each column. Leave out TRUE to read across each row instead (A2, B2, C2, A3, and so on).
Excel TOCOL formula stacking three columns into one column
TOCOL stacks columns A, B, and C into one column and skips blanks.

Both formulas spill their results down from the cell you type them in. In Excel 2021 or earlier, copy column B and paste it below the last value in column A, then do the same with column C.

How to Keep the Combined Text After Deleting the Old Columns

If you used a formula, the new column depends on the original columns and breaks if you delete them. First copy the combined column, then right-click and choose Paste Special > Values. Now you can delete the original columns. Flash Fill results are already plain text, so they don’t need this step.

Keep a copy of the original data until you’ve checked the new column, especially before you delete anything.

Combining Text Is Different From Merging Cells

Merge & Center changes the worksheet layout. It doesn’t join the values. Only the upper-left cell’s contents stay and the contents of the other merged cells are deleted, so use a joining formula for names or other text you need to keep.

If you want one cell to span several columns instead of joining their contents, merge cells in Excel.

If You See a #NAME? Error

  • #NAME? error. Your version doesn’t have the function you typed. CONCAT and TEXTJOIN need Excel 2019 or later or Microsoft 365, and TOCOL and VSTACK need Microsoft 365 or Excel 2024. Use the & formula or CONCATENATE instead, and check the spelling.
  • The cell shows the formula instead of the result. The cell is formatted as text. Select it, click Home, set the number format box to General, then click in the formula bar and press Enter.
  • Double spaces or stray commas. One of the source cells is blank. Use TEXTJOIN with TRUE, or wrap the & formula in TRIM: =TRIM(A2&" "&B2&" "&C2). TRIM removes extra spaces but not extra commas.
  • The result won’t update. Flash Fill and pasted values are fixed text. Use a formula if you need the combined column to change with the originals. If a formula doesn’t update, check that Formulas > Calculation Options is set to Automatic.
  • #VALUE! error from CONCAT or TEXTJOIN. The combined text is over 32,767 characters. Join fewer cells per formula.

Combining Columns Questions

Can I combine more than three columns?

Yes. Add more cells to the & formula or CONCAT, or give TEXTJOIN a wider range such as A2:F2. TEXTJOIN accepts up to 252 text arguments. To show the combined text in a box that floats over the sheet, you can link an Excel text box to the formula cell.

Do these methods work in Excel for Mac?

Yes. CONCAT and TEXTJOIN work on Windows or Mac with Office 2019 or later or Microsoft 365, and Flash Fill works in Excel for Mac too. The & formula works in any version.

Can I combine the columns in the same cell as the original data?

Not with a formula, because a formula in A2 can’t refer to itself. Put the combined text in a new column, paste it as values, then delete or overwrite the original columns.

Can I use the combined text in calculations?

Joined results are always text, even when they contain numbers. Keep the original number columns for any math, and use the combined column for labels, mailing lists, and lookups.

More Excel Guides