repeating a character across the width of a column
 

I've seen it done that a single character was entered into a cell (eg a dash)
and the effect was that the entire cell width was filled with a repetition of
that character. If I widen the cell, more characters appear.

How is this done please?
TIA, Greg

Hi!

One way:

=REPT("-",255)

However, if the cell to the immediate right is empty then the dashes will
overflow into other columns.

Biff

"gvm" wrote in message
...
I've seen it done that a single character was entered into a cell (eg a
dash)
and the effect was that the entire cell width was filled with a repetition
of
that character. If I widen the cell, more characters appear.

How is this done please?
TIA, Greg

format|cells|alignment tab|horizontal text alignment box|Fill

Is another way.

gvm wrote:

I've seen it done that a single character was entered into a cell (eg a dash)
and the effect was that the entire cell width was filled with a repetition of
that character. If I widen the cell, more characters appear.

How is this done please?
TIA, Greg

--

Dave Peterson

I was looking for that but couldn't remember where it was!

Biff

"Dave Peterson" wrote in message
...
format|cells|alignment tab|horizontal text alignment box|Fill

Is another way.

gvm wrote:

I've seen it done that a single character was entered into a cell (eg a
dash)
and the effect was that the entire cell width was filled with a
repetition of
that character. If I widen the cell, more characters appear.

How is this done please?
TIA, Greg

--

Dave Peterson

that's it, thanks Dave