Cell

J

John

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

How can I do this?
Regards,
 
B

Bill Ridgeway

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
 
B

Bob Phillips

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)
 
G

Greg Wilson

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
 
R

Ragdyer

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.
 
Top