| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Line of Characters
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mathematics: How to display numbers/characters with a line over th | Excel Discussion (Misc queries) | |||
| counting characters in a line | Excel Discussion (Misc queries) | |||
| how to get rid of all Tabs, carriage returns, or new line characters | Excel Discussion (Misc queries) | |||
| How do I get rid of line feed characters in wrapped text? | Excel Discussion (Misc queries) | |||
| Find/Replace carriage return & line feed characters in Excel. | Excel Worksheet Functions | |||
Linear Mode
