Add Spaces to a Cell Using REPT – Excel & Google Sheets

This tutorial demonstrate how to add multiple spaces to a cell in Excel and Google Sheets.

add spaces to cell Main Function

Add Spaces to a Cell

If you need to add multiple places to a cell, you can use the REPT Function:

add spaces to cell 01

In the example above we added 10 spaces to the beginning of the cell.

With the REPT function we can also add a specified number of spaces (or other characters) between concatenated strings.

add spaces to cell 02

Add Spaces To Cell in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.

add spaces to cell Google Function

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!