enter specific number of characters based off a number in a different cell.

[sgj52084]

I am using wingdings font, the Flag symbol (Shft+o), I want to be able to show a certain amount of Flags in a cell based of the number in another cell.

Example:
Cell A1 shows the number "80"
Cell B1 should have 80 Flags/characters.

Any ideas??

 

[Jonmo1]

Welcome to the board.

You can use the REPT function.

=REPT("A",A1)

A1 = 80
"A", you need to change that to whatever character produces the flag in the windings font

 

[Puertorekinsam]

=rept("o",a1)

 

[sgj52084]

Welcome to the board.

You can use the REPT function.

=REPT("A",A1)

A1 = 80
"A", you need to change that to whatever character produces the flag in the windings font

Thank you! That worked perfectly!

 

[Jonmo1]

You're welcome.

 

[sgj52084]

Another perfect answer! Thanks!