I have a spread sheet for a game I am creating. In this, there are different skills with a corresponding level. Next to this, I have a number of boxes that I want the players to tick off. The number of boxes correspond to the level of the skill. So its a really simple set up. My question is, can I have Excel populate the cell with the boxes automatically based on the number in the cell next to it (see the hard coded example below).

enter image description here

So, for example, I want to put a 5 in C5 and in D5 automatically populates 5x"q"'s or qqqqq (font is windings, which gives me the boxes). In lay-mans terms, I want a formula in cell D5 = REPCHAR($C5, "q") to then generate the string "qqqqq" in D5.

1 Answer 1


What you're looking for is the REPT(text, num_times) function.

For your example, D5 would be =REPT("☐", C5)


  • ah great! learned something new today! thank you. :)
    – GenDemo
    Jul 2, 2020 at 4:07

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .