repeating a character across the width of a column

G

gvm

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
 
B

Biff

Hi!

One way:

=REPT("-",255)

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

Biff
 
D

Dave Peterson

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

Is another way.
 
Top