To add a space when joining text in Excel, include a space in quotation marks as an argument: with a first name in A2 and a last name in B2, enter =CONCAT(A2, " ", B2). The result puts one space between the two values; CONCAT does not insert spaces automatically.
How the CONCAT space formula works
CONCAT joins text values in the order you supply them. Each cell reference or text value is a separate argument, and a space is itself a text value. The quotation marks tell Excel that the character between them is a literal space, rather than a blank argument or an instruction to insert a separator.
For example, if A2 contains Maya and B2 contains Chen, the formula produces Maya Chen. The same pattern works for other combinations, such as a city and state, a product name and size, or a first and middle name. To enter it, select the cell where you want the combined result, type the formula, and press Enter. To use it for more rows, drag the fill handle down or double-click it when adjacent data indicates the range to fill.
With a first name in A2 and a last name in B2, the formula is =CONCAT(A2, " ", B2). For Maya in A2 and Chen in B2, the result is Maya Chen.
The space must be placed between the two references. If you put it at the start or end, the result will have a leading or trailing space instead. You can add more than one literal space if you need a wider gap, but one ordinary space is usually right for names and labels. A formula may appear to work even when an unintended trailing space is present; that extra character can affect sorting, matching, and later data cleanup.
Join three or more values with spaces
For several pieces of text, place a space between each pair of values that should be separated. Suppose A2 has a first name, B2 a middle name, and C2 a last name. If all three cells are filled, you can use the following formula.
With a first, middle, and last name in A2, B2, and C2, respectively, enter =CONCAT(A2, " ", B2, " ", C2). If the cells contain Maya, Lin, and Chen, the result is Maya Lin Chen.
That direct formula is easy to read, but it also makes a space for every boundary. If B2 is empty, the output can contain two spaces between the first and last names. If A2 or C2 is empty, the result can begin or end with a space. Those characters may not be obvious on screen, but they are still part of the result and can cause trouble in other formulas or exported data.
When you know all the component cells are populated, CONCAT is a straightforward choice. If some values may be blank, consider TEXTJOIN or a cleanup step instead. The right approach depends on whether a blank value should be ignored, represented by an empty gap, or treated as a data problem that needs correcting.
Use the ampersand as a simple alternative
Excel’s ampersand operator (&) joins values too. For a simple two-cell combination, it often makes the formula shorter and is widely understood in older Excel workbooks. You still need to add the space explicitly as a quoted text value.
With a first name in A2 and a last name in B2, enter =A2&" "&B2. If A2 is Maya and B2 is Chen, the result is Maya Chen.
CONCAT and the ampersand both join text; neither adds a separator on its own. Choose CONCAT if you prefer a function-style formula or are combining several arguments. Choose the ampersand for a compact expression or when maintaining a workbook that already uses it. For this basic task, the result is the same. The ampersand is an operator, not a function, so it does not use parentheses around its inputs.
Use TEXTJOIN when some cells may be blank
TEXTJOIN is designed for joining values with a chosen delimiter. Its first argument is the delimiter, so a single space there is applied between the non-ignored values. Its second argument determines whether empty cells are ignored. This makes it useful for combining a list of optional fields without leaving extra spaces where blanks occur.
With optional name parts in A2:C2, enter =TEXTJOIN(" ", TRUE, A2:C2). If A2 contains Maya, B2 is empty, and C2 contains Chen, the result is Maya Chen.
In this example, TRUE tells Excel to skip empty cells. If the second argument is FALSE, empty cells are included in the joining process and can result in adjacent delimiters. TEXTJOIN can also combine a vertical range, such as A2:A10, or a larger horizontal range. It is available in Microsoft 365 and Excel 2019 or later; older Excel versions may not recognize it.
TEXTJOIN ignores genuinely empty cells when asked to do so, but a cell that looks blank may contain a space or a formula returning an empty string. Those are not always treated like a truly empty cell. If results still look oddly spaced, inspect the source cells and consider cleaning the text, rather than assuming the delimiter is faulty.
Clean up extra spaces in the result
TRIM can remove leading and trailing ordinary spaces and reduce repeated ordinary spaces within a text string to one. It is helpful when source cells are inconsistently entered or a basic CONCAT formula may leave extra spaces around a blank value. For two name parts, it can wrap the whole joined expression.
With a first name in A2 and a last name in B2, enter =TRIM(A2&" "&B2). If A2 contains Maya and B2 is empty, the result is Maya, without a trailing space.
TRIM is not a universal text-cleaning tool. In particular, it does not remove nonbreaking spaces, a different character that can appear in text copied from websites or other systems. Also, TRIM reduces repeated spaces inside the combined value, which may not be desirable if multiple spaces are meaningful in your data. Keep an untouched copy of source data when the exact original text matters, and check a few results before filling a cleanup formula down a large range.
Preserve number and date formatting
When Excel joins a number or date directly, it uses the underlying value rather than necessarily preserving the way the cell is displayed. A date formatted in a cell as 2 November 2026, for example, is stored as a serial number. Joining that cell with text can therefore produce an unexpected numeric result. To control the appearance, use TEXT to specify a format within the formula.
With a date in B2, enter =CONCAT(A2, " ", TEXT(B2, "mmmm d, yyyy")). If A2 contains Due and B2 is the date 2 November 2026, the result is Due November 2, 2026.
TEXT returns text formatted according to the format code you provide. You can use codes such as 0% for a percentage or $#,##0.00 for a currency-style display, choosing a format that suits the intended output. Since the result is text, it is no longer a numeric date or amount for calculations. Keep the original numeric cells for calculations, and use the joined text for labels or presentation.
Choose the right method and check compatibility
For Microsoft Excel for Microsoft 365 on Windows, CONCAT, TEXTJOIN, TRIM, and TEXT are available for these examples. The same formulas generally work in current Excel for Mac and Excel for the web; the interface for entering and filling formulas may differ, but the space argument works the same way. In some regional settings, Excel uses semicolons rather than commas between formula arguments. If a valid formula is rejected, check the list separator expected by your Excel installation.
CONCAT replaced the older CONCATENATE function, which remains in Excel for compatibility with older workbooks. The older function can also join text, but it does not automatically add spaces either. TEXTJOIN is more convenient for applying one delimiter across a range, especially when empty cells should be skipped. The ampersand is the simplest alternative for a small number of values. All these methods return text, so a number joined into a label will not remain a number for arithmetic.
- Use CONCAT with a quoted space when joining a few known values.
- Use TEXTJOIN when you want the same delimiter between many values or need to ignore empty cells.
- Use the ampersand for a concise formula or compatibility with older formulas.
- Use TEXT inside the formula when a number or date needs a specific displayed format.
Common problems and quick checks
If the formula result has no visible gap, check that the space is between two quotation marks and that those quotation marks surround a literal space. A formula such as =CONCAT(A2,B2) joins the cells directly, while =CONCAT(A2, " ", B2) includes the separator. If the result has too much space, inspect the source cells for spaces already present at the beginning or end of their contents.
If Excel displays the formula itself instead of the result, the cell may be formatted as Text, or Show Formulas may be on. Change the cell format to General, then re-enter the formula; changing the format alone may not recalculate text already entered as a formula. Show Formulas can be toggled with Ctrl+` on Windows. On Mac, the shortcut can vary with keyboard layout; use the Formulas tab’s Show Formulas control if needed.
If the answer looks right but a lookup or comparison fails, hidden spaces are a likely cause. Check the source and result cells for leading, trailing, or repeated spaces. Also make sure the formula uses straight quotation marks, not typographic curly quotation marks copied from formatted text. Finally, remember that concatenation combines values into text; it does not add, average, or otherwise calculate the numbers inside the cells.
Frequently Asked Questions
Does CONCAT automatically add a space in Excel?
No. CONCAT joins exactly the text and cell values supplied. Include a quoted space as an argument, as in =CONCAT(A2, " ", B2), to put one space between two cells.
How do I combine first and last names with a space?
With the first name in A2 and last name in B2, use =CONCAT(A2, " ", B2). If some name parts may be blank, TEXTJOIN with a space delimiter and TRUE to ignore empty cells may avoid unwanted gaps.
Can I use CONCAT with more than two cells?
Yes. Add each cell reference and any needed spaces as arguments. For a three-part name in A2:C2, for example, use =CONCAT(A2, " ", B2, " ", C2), provided all three parts contain values.
Why does my joined date look like a number?
Excel stores dates as numbers and may use that underlying value when joining. Wrap the date cell in TEXT with a format code, such as TEXT(B2, "mmmm d, yyyy"), to control how it appears in the combined result.
Should I use CONCAT or TEXTJOIN?
Use CONCAT for a few specific values when you want to place each separator yourself. Use TEXTJOIN when applying one delimiter to a range, especially if empty cells should be ignored. Both methods need an explicit space delimiter or argument.
Related
- Excel Data Model: What It Is and How to Use It
- Excel Data Model: Can You Turn It Off?
- Excel Data Model and SharePoint: How They Work
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Concatenate an Excel List: Join Values With DelimitersTo concatenate an Excel list into one cell, use TEXTJOIN: with the values in A2:A6, enter =TEXTJOIN(", ",TRUE,A2:A6).…
- Rank in Excel by Multiple Criteria: Formulas and TipsWith primary scores in B2:B5, secondary scores in C2:C5, and a third tie-breaker in D2:D5, enter this in…
- Excel LAMBDA Function Examples for Reusable FormulasExcel LAMBDA lets you turn a formula into a reusable function: define it with =LAMBDA(parameters, calculation), save it…
- COUNTIF Excel Cell Color: Methods That Work ReliablyExcel’s COUNTIF function cannot count cells by fill color on its own: its criteria are based on cell…
- Round Numbers in Word Mail Merge: A Step-by-Step GuideTo round numbers in a Word mail merge, add a numeric picture switch to the merge field, such…
- Round Excel to Significant Figures: Formulas and MethodsTo round a number in Excel to a chosen number of significant figures, put the value in A2…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.