use the REPT Function:
Point and Click the cell in which you want the Repeated
Enter the formula:
equal sign – Indicates to Excel that you are entering a function
This is the name of the function term
parenthesis – Indicates the start of the argument, (which text to
you would like to repeat by either:
a cell that contains the text
a comma and then input the # of times to repeat by either:
an integer, or
a cell that contains the correct amount to repeat
Close parenthesis – Indicates the end of the REPT argument.
The function will
automatically display the text given as many times as told (no spaces).