Excel CONCAT Formula: Combine Two Columns With a Space

Formulas & functions · Updated November 18, 2026

To combine two columns in Excel, enter =CONCAT(A2," ",B2) in a blank cell, replacing A2 and B2 with the two cells in the same row. The formula joins their contents with a space; for example, Maya in A2 and Chen in B2 produce Maya Chen. You can also use the ampersand operator: =A2&" "&B2.

The quickest way to combine two columns

For a typical list—such as first names in column A and last names in column B—put the formula in the first empty column on the same row as your data. In Excel for Microsoft 365 on Windows, if the first record is in row 2, click C2 and enter this formula:

With first names in A2:A100 and last names in B2:B100, enter this in C2:

=CONCAT(A2," ",B2)

Press Enter. If A2 contains Maya and B2 contains Chen, C2 displays Maya Chen. To apply the formula to more rows, select C2 and drag its small fill handle at the lower-right corner down the column. Excel adjusts the references for each row: the next formula uses A3 and B3, then A4 and B4, and so on.

To fill a selected range quickly, enter the formula in the top cell, select that cell and the cells beneath it, then choose Home > Fill > Down. The formula result is text in the worksheet, but the formula itself remains editable in the formula bar. If you need a fixed text-only copy, copy the results and use Home > Paste > Paste Values.

What CONCAT does—and what it does not do

CONCAT joins text from the items you give it. It does not automatically insert spaces, commas, hyphens, or other separators, so include the separator as a quoted text argument when you need one. For example, the space in =CONCAT(A2," ",B2) is an explicit character between the two cell references. Without it, the result of joining Maya and Chen would be MayaChen.

CONCAT is the modern successor to CONCATENATE. Both can combine values, but CONCAT accepts ranges as well as individual references, while CONCATENATE is retained mainly for compatibility with older workbooks. For combining two cells on each individual row, either function can work; the ampersand operator is another compact option.

With a first name in A2 and a last name in B2, this formula uses the ampersand operator and returns Maya Chen when those are the cell values:

=A2&" "&B2

The ampersand is an operator, not a function, so it does not need a function name or parentheses. Many Excel users find it easy to read when joining a few values. CONCAT can be more convenient when a formula has several pieces because the items appear together inside its parentheses.

Choose the separator and order you need

The separator is part of the formula, so you can tailor the result to its purpose. A full name usually needs a space; an address, code, or label may need punctuation. You can also reverse the order of the two columns by reversing the references.

  • Space: separates first and last names, or other words.
  • Comma and space: useful for a “surname, given name” display.
  • Hyphen: can join parts of a code or a compound label.
  • No separator: appropriate when the values are parts of a continuous identifier.

With a given name in A2 and surname in B2, this formula puts the surname first and returns Chen, Maya when the cells contain Chen and Maya in the corresponding surname and given-name positions:

=B2&", "&A2

For clarity, that example assumes B2 contains the surname Chen and A2 contains the given name Maya; it returns Chen, Maya. The cell order, not the column heading, determines the order of the joined text. Check the references carefully if you are rearranging fields.

Combining more than two columns

You can add more cell references and separators to a CONCAT formula. This is useful for joining first name, middle initial, and surname, or combining several address fields. Include a separator between each pair of items where one is wanted; Excel will not add punctuation for you.

With first name in A2, middle initial in B2, and last name in C2, this formula returns Maya R. Chen when the cells contain Maya, R., and Chen:

=CONCAT(A2," ",B2," ",C2)

CONCAT can also join several individual references, but be cautious about passing whole ranges when you mean to combine each row separately. A formula that combines ranges is not a substitute for a row-by-row formula: use references from one row, then fill the formula down so each result pairs values from the same row.

Handling empty cells and extra spaces

A simple formula can leave an unwanted space if one of the source cells is blank. For instance, joining a name with a blank middle-name cell may leave two spaces between the first and last names. The extra space may be hard to notice on screen but can affect searches, comparisons, or exported text.

For a two-cell join where blank cells should be skipped, TEXTJOIN can apply a space separator and ignore empty cells. With first name in A2 and last name in B2, enter:

=TEXTJOIN(" ",TRUE,A2,B2)

If A2 is Maya and B2 is blank, the result is Maya rather than Maya followed by a trailing space. If both cells contain text, the result is Maya Chen. The TRUE argument tells TEXTJOIN to ignore empty cells; it does not remove spaces that are already present inside the source values. TEXTJOIN is available in modern Excel versions, including Microsoft 365.

If you use CONCAT or ampersands instead, you can conditionally add a separator only when both cells contain values. With A2 and B2 as the two source cells, this formula returns Maya Chen when both are filled, or just Maya if B2 is blank:

=IF(B2="",A2,A2&" "&B2)

That version handles a blank second cell, but if either source can contain extra spaces typed by a user, clean the source data or adapt the formula to trim it. An empty-looking cell may also contain a formula that returns an empty string; TEXTJOIN treats an empty string as empty for this purpose.

Preserving dates, numbers, and display formats

When Excel joins a date or number with text, the result may not look like the source cell’s displayed format. A date is stored as a number, and a cell’s visual date format does not automatically become part of the concatenated text. The same issue can arise with currency, percentages, and numbers padded with leading zeros.

Use TEXT to specify the format you want included in the joined result. With an event name in A2 and a real Excel date in B2, this formula displays the date as month/day/year:

=A2&" - "&TEXT(B2,"m/d/yyyy")

If A2 contains Meeting and B2 is the date January 5, 2026, the result is Meeting – 1/5/2026. The format code controls how the date appears in the resulting text; it does not change the stored date in B2. Choose a format appropriate for the audience, especially if the workbook may be opened with different regional date conventions.

For numeric identifiers such as 007, remember that Excel may interpret an entry as the number 7 and discard leading zeros unless the source is stored as text or formatted appropriately. If the source is numeric and you need a fixed width, TEXT can add a display pattern. With a label in A2 and a number in B2, this formula displays a three-digit number:

=A2&"-"&TEXT(B2,"000")

If A2 is Item and B2 is 7, the result is Item-007. Use a format pattern that matches the identifier rules; do not apply a numeric format blindly if the values are meant to be numbers for later calculations.

Common problems and how to fix them

  • The result has no space: add a quoted space between the references, such as =A2&" "&B2.
  • The formula appears as text: check whether the cell is formatted as Text or whether the entry begins with an apostrophe. Change the cell format to General, then re-enter the formula.
  • The wrong row is combined: verify that both references use the same row, such as A2 with B2, before filling down.
  • A date becomes a number: wrap the date reference in TEXT and provide a date format, as shown above.
  • The formula shows an error after copying: check that the references have not shifted to empty or unintended columns. If a column must stay fixed when copying sideways, use an absolute reference such as $A2.

Excel formulas normally use commas between function arguments in the English-language setup shown here. Depending on your Windows regional settings, Excel may require semicolons instead. If Excel rejects a formula that otherwise looks correct, check the list separator used by your installation.

Frequently Asked Questions

What is the simplest formula to combine two columns in Excel?
For values in A2 and B2, use =A2&B2 if you want no separator, or =A2&" "&B2 for a space. Fill the formula down to combine the corresponding cells in later rows.

Is CONCAT better than the ampersand symbol?
Both can join cell contents. CONCAT is a named function and works well when a formula has several pieces; ampersand is concise for a couple of references. Choose the version that is easiest for you or your colleagues to read and maintain.

How do I combine two columns without a space?
With values in A2 and B2, use =CONCAT(A2,B2) or =A2&B2. Neither formula inserts a separator automatically.

Can I combine two columns and remove blank cells?
Yes. For the values in A2 and B2, =TEXTJOIN(" ",TRUE,A2,B2) joins nonempty values with a space and ignores empty cells. It does not remove extra spaces already typed into a cell.

How do I keep the combined results but remove the formulas?
Copy the formula results, then use Home > Paste > Paste Values to replace the formulas with their current text results. Keep a copy of the original data if you may need to revise the combinations later.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.