Repeat characters to cell width

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

Guest

Greetings and TIA for your time,
I vaguely remember with Lotus 123 that it was possible to repeat characters
to the cell width without specfying the cell width. For example, if I
remember right, "/-" would produce 1 cell width of hyphens: -----------------
Is there an equivalent for Excel?
 
Hi David,

* will cause the following character to fill the width.

Use it in Format>Cells>Number>Custom

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

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

Data Validation drop-down width, with named range source (XL03 and 4
Repeating characters to fill cell width 3
repeating a character across the width of a column 4
Inserting a hyphen after the 3rd character 3
Excel autofit row height not working 0
2 Question: Coloumn width, Filename 2
fixing column width 1
Setting column widths when mapping out a field trial. 1

Back
Top