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.
- Click the first empty cell in the column where you want the combined text, such as D2.
- Type
=A2&" "&B2&" "&C2. Each" "is a space inside quotation marks, which Excel places between the values. - Press Enter. D2 now shows the three values joined, such as Mary Ann Smith.
- 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.

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
- Click the cell where you want the result, such as D2.
- Type
=CONCAT(A2," ",B2," ",C2). - 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
- Click D2.
- Type
=TEXTJOIN(" ",TRUE,A2:C2). - Press Enter, then drag the fill handle down.

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.

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.
- Type the combined text for the first row yourself, such as Mary Ann Smith in D2, and press Enter.
- Start typing the next row in D3. Excel shows a gray preview of the rest of the column.
- 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.
- Click any cell in your data and press Ctrl+T to make it a table. Confirm My table has headers and click OK.
- Click Data > From Table/Range. The Power Query Editor opens.
- Click the first column header, then hold Ctrl and click the other two in the order you want them joined.
- Click Add Column > Merge Columns. Choose a separator, such as Space or Comma, type a name for the new column, and click OK.

- 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).

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
- How to combine first and last names in Excel
- How to AutoFit columns and rows in Excel
- How to calculate percentage in Excel
- How to change the default font in Excel
- How to remove duplicates in Excel

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.