Excel CONCATENATE Formula With a Space: Clear Examples

Formulas & functions · Updated November 18, 2026

To join two Excel cells with a space between them, use the ampersand operator and put a space inside quotation marks: =A2&" "&B2. If A2 contains Maya and B2 contains Chen, the result is Maya Chen. The space is text that you add to the formula; Excel does not insert one automatically.

How a space works in a concatenation formula

Concatenation means joining text or values end to end. In an Excel formula, the ampersand (&) joins the items on either side of it. A quoted space, written as " ", is one of those items. The formula therefore joins the first cell, one space character, and the second cell in that order.

For example, with a first name in A2 and a last name in B2, =A2&" "&B2 makes a single text value. The source cells remain unchanged. The result is a calculated value in the formula cell, so changing either source cell updates the joined result.

The quotation marks matter: " " contains one blank character, while "" contains no characters. A formula such as =A2&B2 joins the contents directly, so Maya and Chen become MayaChen. A formula with two spaces inside the quotes would put two spaces in the result.

Use the ampersand for a simple two-cell formula

The ampersand is a concise way to combine two or more pieces of text and works in current Excel for Microsoft 365 on Windows. To enter the basic formula:

  1. Select the cell where you want the combined result.
  2. Type an equals sign, select or type the first cell reference, enter &" "&, and then select or type the second reference.
  3. Press Enter. If you need the same pattern for other rows, copy or fill the formula down.

With first names in A2 and surnames in B2, the formula is =A2&" "&B2. If A2 is Maya and B2 is Chen, it returns Maya Chen. In a worksheet, use cell references rather than typing each person’s name into the formula; then the result can follow changes to the source data.

You can join more than two cells by repeating the pattern. With a street name in A2, a street type in B2, and a unit number in C2, =A2&" "&B2&" "&C2 inserts one space between each piece. If the cells contain Oak, Street, and 4, the result is Oak Street 4. This direct pattern is easy to read when every part is required.

Use CONCATENATE or CONCAT instead

Excel also has functions for joining text. CONCATENATE is the older function name and remains available for compatibility. With first names in A2 and surnames in B2, =CONCATENATE(A2," ",B2) returns Maya Chen when those cells contain Maya and Chen. The quoted space is a separate argument between the two cell references.

CONCAT is a newer alternative that accepts text arguments and ranges. With the same values in A2 and B2, =CONCAT(A2," ",B2) also returns Maya Chen. For a simple two-cell join, CONCAT does not provide a special advantage over the ampersand; use whichever form is clearer to you or consistent with the workbook. CONCATENATE can be useful when maintaining an older workbook that already uses it.

Both CONCAT and CONCATENATE require you to supply the separator yourself. Neither function automatically adds spaces between cell values. Excel versions and file compatibility can affect which functions are available, so the ampersand is a dependable choice when a formula needs to work in a broad range of Excel versions.

Choose the right separator for your data

A space is appropriate for names, addresses, and labels that need readable separation, but the separator should match the intended output. You can put punctuation or other text between values by changing the quoted text. For example, a comma followed by a space is written as ", "; a slash can be written as "/". The quote marks tell Excel that the characters are literal text.

With a city in A2 and a state abbreviation in B2, =A2&", "&B2 returns Seattle, WA when the cells contain Seattle and WA. With a product code in A2 and a size in B2, =A2&"-"&B2 returns ITEM-XL if the values are ITEM and XL. These examples show why it is worth deciding on punctuation and spacing before filling a formula down a long list.

If you are joining several cells with one consistent separator, TEXTJOIN can be more convenient than repeating the separator. With values in A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) joins the nonempty values using one space and ignores empty cells. If A2 contains Maya, B2 is blank, and C2 contains Chen, the result is Maya Chen. TEXTJOIN is available in Microsoft 365 and Excel 2019 or later; use the ampersand pattern if you need compatibility with older releases.

Handle blank cells without extra spaces

A straightforward formula can leave an unwanted space when one of its source cells is blank. With a first name in A2 and a last name in B2, =A2&" "&B2 returns Maya followed by a space if B2 is empty. That trailing space may be hard to see on screen, but it can affect comparisons, exports, or later text processing.

For two cells where blanks should be skipped, TEXTJOIN can avoid adding a separator for an empty cell. With the first and last names in A2 and B2, =TEXTJOIN(" ",TRUE,A2,B2) returns Maya if A2 contains Maya and B2 is blank, and returns Maya Chen when both are filled. The TRUE argument tells Excel to ignore empty cells. This is useful when optional fields may be missing.

For a small fixed pattern, you can also make the space conditional. With a required first name in A2 and an optional middle name in B2, =A2&IF(B2="",""," "&B2) returns Maya when B2 is blank and Maya Lee when B2 contains Lee. This approach makes the rule explicit, but the formula becomes longer as you add more optional fields. For multiple optional items, TEXTJOIN is often easier to maintain.

Blank is not always the same as a cell containing a formula that returns an empty string. TEXTJOIN’s ignore-empty setting handles empty text in common cases, but spaces typed into a cell are not empty. If a result still has odd gaps, inspect the source cells for spaces or other invisible characters.

Preserve number and date formatting

When Excel combines a number or date with text, the displayed result may not retain the source cell’s number format. Concatenation produces text, and a date can appear as its underlying serial number rather than as a familiar calendar date. If formatting matters, convert the value to text in the formula with TEXT and specify the format you want.

With a label in A2 and a real Excel date in B2, =A2&" "&TEXT(B2,"mmmm d, yyyy") returns Meeting May 6, 2026 when A2 contains Meeting and B2 contains May 6, 2026. The TEXT format code spells out the month and uses a four-digit year. The formula does not change the date stored in B2; it controls how that date is represented in the combined text.

With an item name in A2 and a numeric quantity in B2, =A2&": "&TEXT(B2,"0.00") returns Flour: 2.50 when A2 contains Flour and B2 contains 2.5. The format code displays two decimal places. Choose a format that suits the data: for instance, a quantity might need no decimals, while a measurement may need two. Remember that after concatenation the entire result is text, not a number that Excel can directly total.

Common problems and how to fix them

  • The words run together: Check that the formula includes &" "& between the cell references. A separator must be added explicitly.
  • There is too much space: Check how many spaces are inside the quotes and whether the source cells already begin or end with spaces.
  • A date becomes a number: Use TEXT with a date format, as in the example above, rather than relying on the cell’s display formatting.
  • An empty field leaves a gap: Use TEXTJOIN with its ignore-empty argument set to TRUE, or make the separator conditional for a small formula.
  • The formula appears as text in the cell: Make sure the cell is not formatted as Text and that the entry begins with an equals sign. If necessary, change the cell format to General, then re-enter the formula.

Leading and trailing spaces in source data are another frequent cause of results that look inconsistent. With names in A2 and B2, =TRIM(A2)&" "&TRIM(B2) removes leading and trailing ordinary spaces from each name before joining them. TRIM also reduces repeated ordinary spaces within the text to single spaces. It does not remove every type of invisible whitespace, such as a nonbreaking space copied from some web pages, so pasted data may need additional cleanup if TRIM does not solve the problem.

Also check that you are entering the formula in a different cell from the cells it refers to. A formula that refers to its own result cell can create a circular reference. If you see an error or an unexpected result, verify the references, the quotation marks, and whether the source values are what you expect.

Fill the formula down and manage the result

For a list with names in A2:A100 and B2:B100, enter the two-cell formula in the first result row, then use the fill handle at the lower-right corner of the selected cell to copy it down. Relative references adjust by row: a formula using A2 and B2 becomes one using A3 and B3 on the next row. You can also copy the formula and paste it into the remaining result cells.

Formula results update when their referenced cells change. If you need a fixed text snapshot for an export or handoff, copy the result cells and use Paste Special > Values to replace the formulas with their current results. Do this only when you no longer need the output to update automatically. Keep the original source columns if you may need to revise the combined data later.

Concatenation is best for presentation labels and readable combined fields, not for every data-cleaning task. Keeping first and last names in separate columns can make sorting, filtering, and reporting easier. Create a combined column when a downstream form or system requires it, or when a single display field is genuinely more useful.

Frequently Asked Questions

What is the Excel formula to combine two cells with a space?

Use =A2&" "&B2, replacing A2 and B2 with your cell references. The quoted space is the separator between the two values.

Can I concatenate three cells with spaces between them?

Yes. Join each pair of values with &" "&, or use TEXTJOIN for a range. For example, TEXTJOIN can be useful when some of the cells may be blank.

Why does CONCATENATE not add a space automatically?

CONCATENATE joins only the arguments you give it. Add a separate quoted space argument, such as " ", wherever a space should appear in the result.

How do I avoid extra spaces when a cell is blank?

For several values, use TEXTJOIN with TRUE as its ignore-empty argument. For only a few fields, you can use IF to add a separator only when the optional cell contains a value.

How do I keep a date readable when I join it to text?

Wrap the date cell in TEXT and provide a date format, for example TEXT(B2,"mmmm d, yyyy"). Concatenation creates text, so the original cell’s number format may not carry through automatically.

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.