Line of Characters

[webnntp]

I have cell A1 with a number, let's say 21

I need to find a way to automatically show 21 C's or B's or any
character in cell A2

If A1 changes to 24 then A2 will now show 24 C's or B's

Thanks

 

[smartin]

I have cell A1 with a number, let's say 21

I need to find a way to automatically show 21 C's or B's or any
character in cell A2

If A1 changes to 24 then A2 will now show 24 C's or B's

Thanks

Try
=REPT("C",A1)

 

[webnntp]

Try
   =REPT("C",A1)

Thank you very much