Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell
I want to create within a cell the following text content:
1. xxxxxxxxxxxxxx 2. sssssssssssss 3. bbbbbbbbbbbb How can I do this? Regards, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions |