String of same characters, their amount depending on a given number

[Hitch75]

Hi guys

There is a number in A1, for example 15.
I need a formula in B1 which will return "..............." (15 dots).

So, depending on the number in A1, there will be a certain amount of dots in B1.

Is there an easy way to do it?

[DBY]

Hello
You can use the REPT function:

Please Login or Register  to view this content.

DBY

[Hitch75]

Wow that was easy, I had no idea )
Thanks a lot!