To add a space between two values, join them with the ampersand and a space in quotes: =A1&" "&B1. For more than one space, use REPT to repeat it — =A1&REPT(" ",20)&B1 puts twenty spaces between the two values.
To combine a whole range with a space between each item, TEXTJOIN is quicker than chaining ampersands: =TEXTJOIN(" ",TRUE,A1:A5), where TRUE tells it to skip blank cells.
Two things worth knowing: extra spaces added with REPT will look uneven unless the cell uses a monospaced font, and if you’re adding spaces to line values up in a column, column width or indent is the better fix.
To add a space inside existing text — say between a number and a unit — use SUBSTITUTE or REGEXREPLACE instead: =REGEXREPLACE(A1,"(d)([A-Za-z])","$1 $2") puts a space between digits and letters.
When you combine two values in a single cell, it is usually required to add a space between those values. And sometimes, you need to add more than one space. This tutorial will help you write a formula to add space or multiple spaces in Excel.
Add a Single Space
- First, enter (=) in a cell.
- Refer to the cell with the first value and type an ampersand (&).
- Type a space inside double quotation marks (” “) to specify the space to add, and type another ampersand (&).
- Now, refer to the cell with the second value.
- In the end, hit Enter to get the result.

The moment you hit Enter, you will get both values in a single cell with a space in between.

=A1&" "&B1
Add Multiple Spaces
Now if you want to add more than one space between two values, in this case, you can use the REPT function.

Instead of using a single space in this formula, we have used REPT. And in REPT, we have specified the space and the number of times to repeat it.

As you can see, we have 20 for the number_times argument, which tells the function to return 20 spaces between both words.
=A1&REPT(" ",20)&B1
Add Spaces Between Multiple Values
If you have multiple values and want to add a space between each of the values while combining, you can use the TEXTJOIN function.

In TEXTJOIN, you need to specify the delimiter to add between each value, and here we have a space. After that, TRUE to ignore the blank cells, and in the end, the range to get the values from. TEXTJOIN needs Excel 2019 or later, or Microsoft 365.
=TEXTJOIN(" ",TRUE,A1:A5)
Add a Space After a Specific Number of Characters
To add a space inside a value, like between “ABC” and “123” in “ABC123”, use REPLACE with 0 as the number of characters to replace. It inserts the space at position 4 without removing anything and returns “ABC 123”:
=REPLACE(A1,4,0," ")
Add a Space After Each Comma
If a cell has values separated by commas without spaces, like “red,green,blue”, use SUBSTITUTE to replace each comma with a comma and a space:
=SUBSTITUTE(A1,",",", ")
Add Leading Spaces or Pad to a Fixed Length
To add spaces before a value, put REPT at the start. And to make every value the same length (10 characters here), add as many spaces as are missing:
=REPT(" ",3)&A1
=A1&REPT(" ",10-LEN(A1))
If a value is already longer than 10 characters, the second formula gives #VALUE!, as REPT can’t repeat a negative number of times.
Frequently Asked Questions
Why don’t I see the extra spaces in the cell?
They are there, but with a proportional font, spaces are narrow. Check with LEN, which counts every space.
How do I remove the spaces I added?
Use TRIM, which removes all spaces except single spaces between words.
Can I add a space with CONCAT or CONCATENATE?
Yes. Add ” ” as one of the arguments, like =CONCATENATE(A1,” “,B1).
Thank you!