| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use a Number times an X anh have a column with that number of x's
It is probably easier to just ask for what I want than to describe it but
here goes: Say Column A is a column of integers; Column B is a single lower case text character like x . What I want is for Column C to be a text string of the lower case character in Column B the number in Column A long. See example below: Column A Column B Column C 2 a aa 5 s sssss 7 x xxxxxxx How would you do something like this?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use a Number times an X anh have a column with that number of x's
Hi Mathew
try =REPT(B1,A1) If answer was helpful please say yes "Mathew" wrote: It is probably easier to just ask for what I want than to describe it but here goes: Say Column A is a column of integers; Column B is a single lower case text character like x . What I want is for Column C to be a text string of the lower case character in Column B the number in Column A long. See example below: Column A Column B Column C 2 a aa 5 s sssss 7 x xxxxxxx How would you do something like this?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use a Number times an X anh have a column with that number of
Eduardo: Thanks that was perfect!
"Eduardo" wrote: Hi Mathew try =REPT(B1,A1) If answer was helpful please say yes "Mathew" wrote: It is probably easier to just ask for what I want than to describe it but here goes: Say Column A is a column of integers; Column B is a single lower case text character like x . What I want is for Column C to be a text string of the lower case character in Column B the number in Column A long. See example below: Column A Column B Column C 2 a aa 5 s sssss 7 x xxxxxxx How would you do something like this?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding up the number of times a month is in a column | Excel Worksheet Functions | |||
| Count the number of times specific text appears in a column | Excel Worksheet Functions | |||
| Sum the amount of times a number appears in a column in Excel? | Excel Worksheet Functions | |||
| Count the number of times a name occurs in a column | Excel Worksheet Functions | |||
| How to count the number of times a string appears in a column? | Excel Worksheet Functions | |||
Linear Mode
