To combine two columns in Excel, put a formula in a new column that joins them: =A2&" "&B2 uses the ampersand to link the value in A2, a space, and the value in B2, and copying it down fills the whole column. You can also use =CONCAT(A2," ",B2) in Excel 2019 and later, or =TEXTJOIN(" ",TRUE,A2,B2) when you want to skip blanks automatically. All three leave the original two columns untouched and build the combined result in a third column, which is exactly what you want, since merging the columns themselves would delete one of them.
Joining columns comes up constantly after a conversion, when a name splits into first and last, or a date lands in separate day, month, and year columns and you need one clean field. Here are the formula methods, the no formula shortcut, and how to make the combined column permanent.
How do you combine two columns in Excel?
Click the first cell of an empty column next to your data and type =A2&B2, then press Enter and drag the fill handle down to copy it to every row. The ampersand joins the two values back to back. For cleaner syntax with more cells, =CONCAT(A2,B2) does the same thing in Excel 2019, 2021, and 365. Both leave columns A and B exactly as they were and write the joined text into the new column, so nothing is lost and you can delete the originals later if you want.
How do you combine two columns with a space between them?
Add a space in quotes as its own piece: =A2&" "&B2 puts a single space between the two values, which is what you need for joining a first name and a last name into a full name. Swap the space for any separator you like, so =A2&", "&B2 gives a comma and a space for "City, State", and =A2&" - "&B2 puts a hyphen with spaces around it. The text inside the quotes appears literally, so you control exactly how the two columns read once they are joined.
How do you combine two columns without losing data?
Never use Merge and Center on columns that both hold data, because it keeps only the left column and deletes the right one. Instead build the combined value in a new column with =A2&" "&B2, which reads from both columns without changing either. Your original data stays intact in columns A and B, and the joined result lives safely in the new column. Only after you have confirmed the combined column looks right, and turned it into static values, should you consider removing the source columns.
How do you combine a whole column into one cell?
Use TEXTJOIN to collapse a range into a single cell with a separator: =TEXTJOIN(", ",TRUE,A2:A100) joins every value in the range with a comma and a space, and the TRUE tells it to ignore blank cells so you do not get stray extra separators. This is available in Excel 2019 and later. It is the right tool when you need a comma separated list of names or codes in one cell, rather than a value combined row by row across two columns.
How do you combine two columns without a formula?
Use Flash Fill. In the column next to your data, type the combined result for the first row exactly how you want it, for example "Jane Smith", then press Ctrl and E. Excel detects the pattern and fills the rest of the column instantly. Flash Fill needs a clear example and works from Excel 2013 onward. The one caveat is that its results are static, so if the source columns change later, the Flash Fill column does not update; a formula does. Use Flash Fill for a one time cleanup and a formula for data that keeps changing.
Which method should you use to combine columns?
| Method | Best for |
|---|---|
| =A2&" "&B2 | Quick join of two columns with a separator |
| =CONCAT(A2," ",B2) | Cleaner syntax, Excel 2019 and later |
| =TEXTJOIN(", ",TRUE,A2:A100) | Joining a whole range and skipping blanks |
| Flash Fill (Ctrl and E) | A one time combine with no formula |
How do you combine a column with a date or number?
Joining a date or a formatted number with the ampersand strips its formatting and shows the underlying serial number, so =A2&" "&B2 might return "Invoice 45678" instead of "Invoice 6/1/2026". Wrap the value in TEXT with the format you want: =A2&" "&TEXT(B2,"m/d/yyyy") keeps the date readable, and ="Total "&TEXT(B2,"$#,##0.00") preserves a currency amount. TEXT forces Excel to combine the value the way it looks on screen rather than the raw number underneath, which is the fix whenever a combined field comes out as a string of digits.
How do you keep the combined column after deleting the originals?
A formula that references columns A and B breaks the moment you delete them, so convert the result to static text first. Select the combined column, copy it, then use Paste Special and choose Values to overwrite the formulas with the plain joined text. Now the column stands on its own and you can safely delete the two source columns. Skipping this step is the most common reason a combined column suddenly fills with reference errors after a cleanup.
Combining split fields after a conversion
Converted documents often split one piece of information across columns, a name into first and last, or a transaction date into separate parts, and joining them back is a quick ampersand formula away. Do the opposite job, breaking one crowded column into several, with how to split a cell in Excel, and if everything landed in a single column to begin with, see why a PDF converts to Excel in one column. Clean column by column data is easiest when the PDF to Excel converter preserves the original layout, which also means you can move the statement straight into QuickBooks once the fields line up.
The short version
Combine two columns with =A2&" "&B2 for a quick join, CONCAT for cleaner syntax, or TEXTJOIN to fold a whole range into one cell while skipping blanks. Flash Fill (Ctrl and E) does it with no formula for a one time cleanup. Build the result in a new column so the originals stay safe, and paste it back as values before deleting the source columns so nothing breaks.