Cell
 

I want to create within a cell the following text content:
1. xxxxxxxxxxxxxx
2. sssssssssssss
3. bbbbbbbbbbbb

How can I do this?
Regards,

Cell
 

The formula is REPT("B",4)
where you want to repeat the letter B four times.

You used to be able to (in Lotus123) fill a cell with a character -
regardless of width. it doesn't look as though that's available in Excel.

Regards.

Bill Ridgeway
Computer Solutions

"John" wrote in message
...
I want to create within a cell the following text content:
1. xxxxxxxxxxxxxx
2. sssssssssssss
3. bbbbbbbbbbbb

How can I do this?
Regards,

Cell
 

Type one line, then ALt-Enter, next line etc.

You will have to type 1., 2. etc., there is no numbering facility.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"John" wrote in message
...
I want to create within a cell the following text content:
1. xxxxxxxxxxxxxx
2. sssssssssssss
3. bbbbbbbbbbbb

How can I do this?
Regards,

Cell
 

Assuming you meant it all to be in one cell:

Sub abc()
With ActiveCell
.Value = String(14, "x") & Chr(10) & _
String(13, "s") & Chr(10) & String(12, "b")
End With
End Sub

Assuming you want it in separate cells and the 14, 13, 12 string lengths
were intentional:
Sub def()
Dim i As Integer
Dim arr As Variant
arr = Array("x", "s", "b")
For i = 1 To 3
Cells(i, 1) = String(15 - i, arr(i - 1))
Next
End Sub

Assuming the 14, 13, 12 string lengths were unintentional and you want them
to be the same length (here set to 14):

Sub ghi()
Dim i As Integer
Dim arr As Variant
arr = Array("x", "s", "b")
For i = 1 To 3
Cells(i, 1) = String(14, arr(i - 1))
Next
End Sub

Regards,
Greg

"John" wrote:

I want to create within a cell the following text content:
1. xxxxxxxxxxxxxx
2. sssssssssssss
3. bbbbbbbbbbbb

How can I do this?
Regards,

Cell
 

Although I believe that Bob has correctly interpreted the OP's request (I
could be wrong), this is to address your comment on XL's fill "feature".

Select cell(s), then
<Format <Cells <Alignment tab,
Expand the "Horizontal" box, and click on "Fill", then <OK.

Now, anything typed into the cell will repeat, to fill the cell.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Bill Ridgeway" wrote in message
...
The formula is REPT("B",4)
where you want to repeat the letter B four times.

You used to be able to (in Lotus123) fill a cell with a character -
regardless of width. it doesn't look as though that's available in Excel.

Regards.

Bill Ridgeway
Computer Solutions

"John" wrote in message
...
I want to create within a cell the following text content:
1. xxxxxxxxxxxxxx
2. sssssssssssss
3. bbbbbbbbbbbb

How can I do this?
Regards,