Thread: Line of Characters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
  
Posts: 915
Default Line of Characters
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)
Reply With QuoteReply With Quote