Rept function

[Ri0]

Would it be possible to add a separator in the rept function so that my data would show 5 I's then a space, then 5 more I's?


=rept("I",10)

IIIII IIIII


instead of

IIIIIIIIII

 

[SirJB7]

Hi, Ri0!

Why not =REPT(REPT("I",5)&" ",2)?

Regards!

 

[Ri0]

SirJB7


We are on the right path.


I want always to only have 5 I's and then a space.


so if a cell has 13 it would look like IIIII IIIII III

 

[SirJB7]

Hi, Ri0!

Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.

Regards!

 

[Ri0]

I just solved it, how did you know?


=REPT(REPT("I",B2/(B2/5))&" ",B2/5)&REPT("I",MOD(B2,5))

 

[SirJB7]

Hi, Ri0!

I knew it because that with the trick of the chained REPT your original question was solved. You didn't mention firstly a 13 length string. But glad you solved it too.

Regards!

 

[NARAYANK991]

Hi ,


Try this :


=REPT(REPT("I",5)&" ",INT(A1/5))&REPT("I",MOD(A1,5))


where A1 contains the number of repetitions that you want.


Narayan