Repeat characters to cell width

D

David

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?
 
N

Niek Otten

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
 
Top