Explanation
The REPT function simply repeats values.
In this example, we use the CHAR function to output a character with a code of 110.
This character, when formatted with the Wingdings font, will output a solid square.
This has the effect of outputting one full square per 100 dollars of sales.
Increase or decrease the divisor to suit the data and available space.
For example, =REPT(“x”,5) returns “xxxxx”.
CHAR Function
The Excel CHAR function returns a character when given a valid character code.
CHAR can insert characters that are hard to enter into a formula.
Related videos
How to use CHAR and CODE functions
