Concatenate Excel Text With a Space Between Values

Formulas & functions · Updated November 18, 2026

Yes. To concatenate text from cells A2 and B2 with one space between them, enter =A2&" "&B2; if A2 contains John and B2 contains Smith, the result is John Smith. The ampersand joins the cell values, and the quoted space supplies the separator.

The simplest way to add a space

In Microsoft Excel for Microsoft 365 on Windows, the ampersand operator is a direct, flexible way to combine text. In a blank cell, type an equals sign, select or type the first cell reference, add an ampersand, enter a space inside quotation marks, add another ampersand, and then select or type the second cell reference. Press Enter to calculate the result.

With first names in A2 and last names in B2, the formula is =A2&" "&B2. If A2 is Maya and B2 is Chen, the result is Maya Chen. The quotation marks tell Excel that the character between them is literal text. Without the quoted space, the result would be MayaChen; without quotation marks around the space, the formula would not treat it as a text value.

The formula can also join a cell to typed text. With a product name in A2, you could add a separating space and then a word such as available. If the phrase needs punctuation, include that punctuation inside the quoted text. For example, a comma followed by a space is a different separator from a plain space. The formula result is text in a new cell; it does not change the original contents of A2 or B2.

How the ampersand operator works

The ampersand, &, is Excel’s concatenation operator: it joins text values in the order they appear. A formula can contain more than two pieces, with a separator inserted wherever you want one. With a first name in A2, a middle initial in B2, and a last name in C2, the formula =A2&" "&B2&" "&C2 returns a name with spaces between all three values, provided each cell contains text.

Separators are not automatic. If you want a space between every pair of values, you must include one in the formula or choose a function that supplies a delimiter. This gives you control over spaces, commas, hyphens, slashes, and other punctuation. For example, a city and state might be joined with a comma and a space, while a code might need a hyphen instead.

To reuse the formula for other rows, enter it in the result cell for row 2 and copy it down. Relative references normally adjust as the formula is copied: A2 and B2 become A3 and B3 in the next row. This is useful for combining names or labels in a table. If you need to keep the result while removing the formula, copy the results and use Paste Special > Values.

Choosing between ampersand, CONCAT, and TEXTJOIN

For two or three pieces of text, the ampersand is often easiest to read. Excel also has CONCAT, which joins values without adding any separator, and TEXTJOIN, which can add a chosen delimiter between multiple items. The older CONCATENATE function is still present for compatibility with older workbooks, but Microsoft recommends CONCAT for newer formulas. None of these functions guesses that a space is wanted: the separator must be specified.

  • Ampersand: A&” “&B gives precise control for a small number of pieces. It is easy to add punctuation or different separators in different places.
  • CONCAT: CONCAT(A2,” “,B2) joins the supplied items in order. Include the quoted space as its own argument.
  • TEXTJOIN: TEXTJOIN(” “,TRUE,A2:C2) uses a space as the delimiter between the cells in the range and can skip empty cells when its second argument is TRUE.

With a first name in A2 and last name in B2, the CONCAT formula is =CONCAT(A2," ",B2). It returns Maya Chen when those cells contain Maya and Chen. CONCAT does not insert spaces on its own; the space is the second argument. CONCAT is available in Microsoft 365 and newer Excel releases, including Excel 2019 and later. For a workbook that must work with much older versions, the ampersand or CONCATENATE may be more compatible.

With entries in A2:C2, the TEXTJOIN formula is =TEXTJOIN(" ",TRUE,A2:C2). It inserts a space between nonempty values and ignores empty cells because the second argument is TRUE. TEXTJOIN is available in Excel 2019 and later, including Microsoft 365. If the values need different separators in different positions, an ampersand formula may be clearer.

Handling blank cells without extra spaces

A plain ampersand formula can leave an unwanted space when one of its source cells is blank. For instance, if A2 is empty and B2 contains Chen, the formula that puts a space before B2 can return a result beginning with a space. That character may be hard to notice, but it can affect sorting, matching, or later text processing.

When A2 and B2 may be blank, this formula removes leading and trailing ordinary spaces and reduces repeated ordinary spaces within the result: =TRIM(A2&" "&B2). If A2 is empty and B2 contains Chen, the result is Chen. If both cells are empty, the result is an empty-looking text value. TRIM is useful for this common case, but it is not a universal cleanup tool: it targets ordinary space characters and does not remove every kind of whitespace that might come from copied web data.

For several cells where empty entries should be skipped, TEXTJOIN can be more convenient. With parts of an address in A2:D2, =TEXTJOIN(", ",TRUE,A2:D2) joins the nonempty entries using a comma and a space. If A2 contains 12 Oak Street, B2 is empty, C2 contains Springfield, and D2 contains MA, the result is 12 Oak Street, Springfield, MA. This avoids a doubled comma caused solely by an empty cell.

Be aware that a cell containing a formula that returns an empty string is not necessarily the same as a truly empty cell in every Excel operation. TEXTJOIN with TRUE ignores empty text values as well as blank cells. If a source cell contains spaces rather than being empty, those spaces are still content; clean the source or wrap the combined result in TRIM when appropriate.

Keeping dates, numbers, and currency readable

When Excel joins a number to text, it uses the underlying value rather than reliably carrying over the cell’s display format. A date cell may therefore appear as a serial number in a concatenated result instead of as a date. A value displayed as currency in its original cell may also lose its currency symbol or decimal formatting in the joined text.

Suppose A2 contains an Excel date and B2 contains an event name. To display the date as a month, day, and year, with a dash separating it from the event, use =TEXT(A2,"mmm d, yyyy")&" - "&B2. If A2 represents April 5, 2026, and B2 contains Inspection, the result is Apr 5, 2026 – Inspection. The TEXT function converts the date to text using the specified format pattern before the ampersand joins it to B2.

With a price in A2 and an item description in B2, use =TEXT(A2,"$0.00")&" "&B2 to display two decimal places and a dollar sign before the description. If A2 is 19.5 and B2 is Notebook, the result is $19.50 Notebook. Choose a format pattern that suits the workbook’s currency and regional conventions; a typed dollar sign is not automatically adapted to another currency. Once formatted this way, the result is text, not a numeric value for calculations.

Common problems and how to fix them

If the result has no space, check that the formula contains a quoted space between two ampersands, or that the delimiter argument in TEXTJOIN is quoted correctly. A formula such as =A2&B2 deliberately joins the contents without a separator. If you see quotation marks or an ampersand in the cell instead of a result, check that the entry begins with an equals sign and that the cell is not formatted as Text. Change the format to General and re-enter the formula if needed.

  • Unexpected leading or trailing space: A source cell may be empty or may contain extra spaces. Try TRIM on the combined result, or use TEXTJOIN with TRUE to skip empty entries.
  • Two spaces in the result: A source value may already have a space at its beginning or end. TRIM can remove repeated ordinary spaces from the combined text.
  • A date appears as a number: Wrap the date reference in TEXT and choose a display pattern before joining it to other text.
  • Formula shows instead of calculating: Make sure the cell is not treated as text and that Show Formulas is not enabled for the worksheet.
  • Wrong separator or punctuation: Check the characters inside the quotation marks. A comma, space, or hyphen must be included exactly where it belongs.

Also distinguish joining text from adding a space to a cell’s appearance. Concatenation creates a new text result; it does not insert a character into either source cell. If you need to change the original values permanently, you would need to edit or replace those values rather than rely on a formula result.

Frequently Asked Questions

What is the formula to combine two cells with a space in Excel?
With the two values in A2 and B2, enter =A2&" "&B2. The quoted space is the separator between the cell contents.

Can I concatenate more than two cells with spaces?
Yes. With text in A2, B2, and C2, use =A2&" "&B2&" "&C2. For a longer range where blank cells should be skipped, TEXTJOIN is usually easier to maintain.

Does CONCAT automatically put a space between values?
No. CONCAT joins exactly the arguments you provide. With values in A2 and B2, include a separate quoted space in the formula, as in =CONCAT(A2," ",B2).

How do I avoid extra spaces when a cell is blank?
For two cells in A2 and B2, try =TRIM(A2&" "&B2). For a range such as A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) skips blank or empty-text entries while joining the remaining values.

Can I concatenate a date and text with a space?
Yes. Convert the date to the appearance you want with TEXT before joining it. With a date in A2 and text in B2, use =TEXT(A2,"mmm d, yyyy")&" "&B2. The resulting combined value is text.

Can I remove the formula but keep the combined text?
Yes. Copy the formula results, then use Paste Special > Values to replace the formulas with their displayed results. The original source cells remain unchanged unless you overwrite them separately.

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.