How To Combine 2 Columns in Excel With a Space

Last updated: August 18, 2026

This guide joins columns together. If you need the reverse, pulling one column apart into several, read how to do the opposite of CONCATENATE in Excel. If you want to merge cells into one bigger cell for formatting, that is a different feature, covered in how to combine cells in Excel with Merge and Center.

Joining two columns is the first real data cleanup job most people hit in Excel. You have first names in column A, last names in column B, and you need full names in column C. Or you have a city column and a state column, and a report that wants them in one field.

Excel gives you four ways to do it, plus one that needs no formula at all. They are not interchangeable, and picking the wrong one is why people end up with JohnDoe instead of John Doe, or with a mailing list where every blank middle name leaves a double space.

Which Method Should You Use to Combine Columns?

Rule of thumb: use the ampersand for two columns, TEXTJOIN for three or more, and Flash Fill only when the source data will never change again.

How Do You Combine Two Columns in Excel With a Space?

The ampersand operator is the shortest and most reliable answer, and it works in every version of Excel ever shipped.

Step 1: Click the cell where you want the combined value

With first names in column A and last names in column B, click cell C2.

Step 2: Type the formula

Enter =A2 & " " & B2 and press Enter. The two quotation marks with a space between them are what put the gap between the names. Leave them out and you get JohnDoe.

Step 3: Copy the formula down the column

Double click the small square at the bottom right of the cell, the fill handle, and Excel applies the same formula to every row that has data next to it.

Rule of thumb: anything you want to appear literally in the result, including a space, must sit inside double quotation marks.

CONCAT vs CONCATENATE vs TEXTJOIN vs the Ampersand

These four all join text, so the question is which one to reach for. The differences are real and they show up the moment your data gets messy.

CONCATENATE is the old one. Microsoft has replaced it with CONCAT and states in its own documentation that CONCATENATE is kept only for compatibility with earlier versions. It still works, so old workbooks will not break, but there is no reason to write a new one.

CONCAT is the direct upgrade. Same idea, shorter name, and it accepts a whole range such as =CONCAT(A2:D2) instead of forcing you to list every cell.

TEXTJOIN is the one that solves real problems. You give it the delimiter once, at the front, instead of retyping " " between every cell. More importantly, the second argument controls whether blanks are ignored. With a middle name column that is empty for half your list, =TEXTJOIN(" ",TRUE,A2:C2) gives you clean names, while the ampersand version leaves a double space in every row where the middle name is missing.

The ampersand wins on brevity. For two cells, =A2&" "&B2 is faster to type than any function name and it is the version most Excel users will recognise at a glance.

Rule of thumb: TEXTJOIN is the only one of the four that can ignore empty cells, which makes it the right choice for any list with gaps in it.

How Do You Combine Two Columns Using CONCATENATE, Step by Step?

If you are working in an older file, or you were taught CONCATENATE and want to see it done properly, here is the full walkthrough.

Step 1: Open your workbook and find the two columns

In this example, First Name sits in column A and Last Name sits in column B.

Step 2: Select the cell for the combined result

Click cell C2, under a heading such as Full Name.

Step 3: Enter the CONCATENATE formula

Type =CONCATENATE(A2, " ", B2). The middle argument, a space inside quotation marks, is the separator.

Step 4: Press Enter to see the result

Excel returns the joined value in a single cell.

Step 5: Copy the formula down the column

Double click the fill handle to apply it to the whole dataset.

Rule of thumb: if you are writing a brand new formula, type CONCAT instead of CONCATENATE. Everything else about the syntax is identical.

How Do You Combine a Whole Range of Columns With TEXTJOIN?

Once you get past two columns, listing every cell and every separator becomes painful. TEXTJOIN takes the delimiter once and then a range.

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

The three arguments are, in order, the delimiter to insert between values, whether to ignore empty cells, and the cells to join. Setting the second argument to TRUE is the important part. With TRUE, a row missing a middle name returns Jane Smith. With FALSE, the same row returns Jane Smith with a stray double space that will haunt every lookup and mail merge you run afterwards.

Rule of thumb: TEXTJOIN with TRUE is the only join method that produces clean output from a list with missing values.

How Do You Combine Columns With a Comma, Dash or Other Delimiter?

A space is only one option. Whatever you put inside the quotation marks is what appears between the values, so the same formulas cover every separator you are likely to need.

Rule of thumb: the delimiter is just text, so anything you can type inside quotation marks can sit between your columns.

How Do You Combine Two Columns With a Line Break?

Address blocks and shipping labels usually need the second value on its own line rather than after a space. You cannot type Enter inside a formula, so you use a character code instead.

1. Enter =A2 & CHAR(10) & B2. On Windows, CHAR(10) is the line feed character. On Excel for Mac, use CHAR(13).
2. Select the result cells, go to the Home tab and click Wrap Text.

This second step is the one everyone misses. Without Wrap Text turned on, the line break is genuinely in the cell but Excel renders it as a single line, so it looks as though the formula failed. If the row height does not adjust on its own, drag the row border down or double click it.

Rule of thumb: CHAR(10) inserts the line break, but Wrap Text is what makes it visible. You need both.

How Do You Combine Columns Without Losing Leading Zeros?

Zip codes, part numbers and account IDs often start with a zero. If those values are stored as numbers, Excel drops the leading zero the moment it evaluates them, so 01234 joins as 1234.

The fix is to force the number back into a text format with a fixed width before joining it:

• =TEXT(A2,"00000") & " " & B2 pads a five digit zip code back to five characters.
• =TEXT(A2,"000000") & "-" & B2 does the same for a six digit part number.

Each zero in the format string is one guaranteed digit. If your codes vary in length, the cleaner long term fix is to format the source column as Text before the data is entered, so the zeros are never lost in the first place.

Rule of thumb: wrap any number that must keep a leading zero in TEXT before you join it. See how to add leading zeros in Excel for the full set of options.

How Do You Combine a Date With Text in Excel?

This one surprises people. Join a date column to a text column and instead of Invoice 15/03/2026 you get Invoice 46096. Excel stores dates as serial numbers, counting days since 1900, and joining strips the date formatting away and exposes the raw number.

Wrap the date in the TEXT function with the display format you want:

• =A2 & " " & TEXT(B2,"mm/dd/yyyy") gives Invoice 03/15/2026.
• =A2 & " " & TEXT(B2,"mmmm d, yyyy") gives Invoice March 15, 2026.
• =A2 & " " & TEXT(B2,"mmm-yy") gives Invoice Mar-26.

The same trick handles currency and percentages. TEXT(B2,"$#,##0.00") keeps a price looking like a price, and TEXT(B2,"0.0%") keeps a percentage readable instead of turning into 0.125.

Rule of thumb: joining a date, a currency value or a percentage without TEXT will always output the raw underlying number.

How Do You Combine Two Columns Without a Formula?

Flash Fill reads the pattern from your first example and fills the rest of the column.

1. In C2, type the finished result by hand. If A2 is John and B2 is Doe, type John Doe.
2. Press Ctrl + E, or go to the Data tab and click Flash Fill.

Excel fills the column instantly. Two things to know before you rely on it. First, the result is static text, so if a last name is corrected later the combined column does not update. Second, Flash Fill sometimes needs two examples before it recognises a pattern, especially with inconsistent data such as names that include initials or suffixes.

Rule of thumb: Flash Fill is a one-time snapshot. If the source data will ever change, use a formula instead.

Why Does Merge and Center Delete Your Data?

Many people try to combine columns using the Merge and Center button on the Home tab, then discover half their data is gone.

Merge and Center is a formatting tool, not a data tool. It takes several cells and draws them as one larger cell, which is useful for a title spanning a report. When the cells being merged both contain data, Excel keeps only the upper left value and discards the rest. Excel does warn you, but the warning is easy to click past.

Combining and merging are two different jobs. If your goal is one value built from two, use the formulas above. If your goal is one visually larger cell, that is the Merge and Center feature, covered in our guide to combining cells in Excel.

Rule of thumb: Merge and Center changes how cells look. A formula changes what they contain. Only the formula keeps both values.

How Do You Keep the Combined Column and Delete the Originals?

Your new column C is a formula that points at columns A and B. Delete those columns and every result turns into a #REF! error. Convert the formulas to plain text first:

1. Select column C and press Ctrl + C.
2. Right click the same selection and choose Paste Special, then Values. The keyboard route is Ctrl + Alt + V, then V, then Enter.
3. Confirm the cells now show text rather than formulas by clicking one and checking the formula bar.
4. Now delete columns A and B safely.

Rule of thumb: always Paste Special as Values before deleting a source column, and check the formula bar before you delete anything.

What if You Need to Split a Column Instead?

Everything on this page joins data together. The reverse job, taking John Doe in one cell and splitting it into two, uses a completely different set of tools: TEXTSPLIT, the Text to Columns wizard, and LEFT, RIGHT and MID with FIND.

We cover all of them in how to do the opposite of CONCATENATE in Excel. The two pages are exact opposites, so keep both bookmarked if you clean up data regularly.

Final Thoughts

Combining two columns in Excel comes down to one decision. Two columns and a simple separator, use the ampersand. Three or more columns, or blanks scattered through the data, use TEXTJOIN with TRUE. A number, date or currency value in the mix, wrap it in TEXT first. And whichever you pick, Paste Special as Values before you delete the original columns.

Frequently Asked Questions

How do I combine two columns in Excel with a space?
Type =A2 & " " & B2 in an empty cell and copy it down. The two quotation marks with a space between them insert the gap. =CONCAT(A2," ",B2) and =TEXTJOIN(" ",TRUE,A2:B2) give the same result.

What is the difference between CONCAT and CONCATENATE?
CONCAT is the modern replacement. It accepts a whole range, such as =CONCAT(A2:D2), while CONCATENATE requires each cell to be listed separately. Microsoft keeps CONCATENATE only for compatibility with older workbooks.

How do I combine two columns without a formula?
Use Flash Fill. Type the finished result in the first row of the new column, then press Ctrl + E. The output is static text, so it will not update if the source data changes.

How do I combine columns and keep both original columns?
Put the formula in a new third column rather than using Merge and Center. The originals stay untouched. Merge and Center keeps only the upper left value and deletes the rest.

How do I combine two columns with a line break instead of a space?
Use =A2 & CHAR(10) & B2 on Windows or CHAR(13) on Mac, then turn on Wrap Text from the Home tab. Without Wrap Text the break exists but stays invisible.

Why does my combined column show a number instead of a date?
Excel stores dates as serial numbers and joining exposes the raw number. Wrap the date in TEXT with the format you want, for example =A2 & " " & TEXT(B2,"mm/dd/yyyy").

How do I keep leading zeros when I combine columns?
Wrap the number in the TEXT function with a fixed width format, such as =TEXT(A2,"00000") & " " & B2. Each zero in the format string forces one digit.

How do I join 2 columns and then delete the originals?
Copy the combined column, then use Paste Special and choose Values. That converts the formulas into static text, after which the original columns can be deleted safely.

Related Articles

How To Do the Opposite of CONCATENATE in Excel

How to Combine Cells in Excel With Merge and Center

How to Add Leading Zeros in Microsoft Excel

How to Calculate Percentage Change in Excel

How to Alternate Row Colors in Excel