ExcelBanter - Line of Characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Line of Characters (https://www.excelbanter.com/excel-worksheet-functions/234094-line-characters.html)

Line of Characters

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

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)

[email protected]

Line of Characters

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

All times are GMT +1. The time now is 09:17 PM.