Microsoft Office Tutorials and References
In Depth Information
number_times — This is a positive number that specifies the number of
times to repeat text. If number_timesis 0, REPT returns "" (that is,
empty text). If number_timesis not an integer, it is truncated. The res-
ult of the REPT function cannot be longer than 32,767 characters.
In Microsoft Word, it is easy to create a row of periods between text and a
page number. In Excel, you have to resort to clever use of the REPT function
to do this.
title. The goal in column C is to join enough periods between columns B and A
to make all the page numbers line up.
Figure 11.63. The
REPT function can be used to calculate a certain number of
function can be used to calculate a certain number of
To make this work, you must change the font in column C to be a fixed-
width font, such as Courier New.
The number of periods to print is the total desired length, less the length