On Jun 16, 9:06*pm, smartin wrote:
wrote:
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)

Thank you very much