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??

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??

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??