Add Space (Single and Multiple)

When you combine two values in a single cell, it is usually required to add a space between those values. Even 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 (““) to specify the space to add.
  4. Now, refer to the cell with the second value and type an ampersand (&).
  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 the REPT. And in the REPT, we have specified the space and the number.

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 Multiple Spaces for Multiple Value

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 which will add between each value, and here we have a space. After that, TRUE to ignore the blank cell, and in the end, range to get the values.

=TEXTJOIN(" ",TRUE,A1:A5)

Download Sample File