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

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 8, 2023
Download Example Workbook

Download the example workbook

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 spaces to a cell, you can use the REPT Function:

=REPT(" ",10)&B3

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.

=B3&REPT(" ",20)&C3

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

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List