repeating a character across the width of a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat characters to cell width 2
change zoom based on column width 2
Repeating characters to fill cell width 3
Data Validation drop-down width, with named range source (XL03 and 4
Cell Underline problem underlines across width of cell 1
Counting the number of times a character occurs in a cell 1
Cells only display a maximum number of text characters 4
Characters in cell. 1

Back
Top