How to use the Rept Function in Excel Open Microsoft Excel. Create a table. Inside the table, click into the cell that you want the result to be =REPT (A2, B2).

Use the "Rept" function to more easily add numerous spaces using the format "=REPT (text,repetition)." When combined with the Concatenate function, you can quickly add large amounts of white space ...