Another possibility:

Select the cell(s) in question
GotoFormatCellsAlignment tab
Text alignment
HorizontalFill
OK

--
Biff
Microsoft Excel MVP


"Ron" wrote in message
...
I have a left over Lotus 123 file with a cell in which a character or
combination of characters will repeat to fill that cell. I have forgotten
the key strokes used to create that original cell.

I imported that file into Excel 2002, and it works well but the only way I
can make new cells repeat characters within them is by copying the
original
cell and then pasting its format into the new cell.

How can I make one or more characters repeat themselves withn a cingle
cell?