30 Advanced Excel Tips for 2026

Excel Champs / Excel Formulas List / How to Add Space (Single and Multiple) in Excel (Formula)
By Puneet Gogia (Microsoft MVP)

How to Add Space (Single and Multiple) in Excel (Formula)

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

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

  1. First, enter (=) in a cell.
  2. Refer to the cell with the first value and type an ampersand (&).
  3. Type a space inside double quotation marks (” “) to specify the space to add, and type another ampersand (&).
  4. Now, refer to the cell with the second value.
  5. In the end, hit Enter to get the result.
add-single-space

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

values-in-a-cell-with-space
=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.

add-multiple-spaces

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.

using-rept-to-add-multiple-spaces

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.

add-multiple-space-for-multiple-values

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).

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel

1 thought on “How to Add Space (Single and Multiple) in Excel (Formula)”

Leave a Comment