Part IV: Using Advanced Excel Features
568
Filling a cell with a repeating character
The asterisk (*) symbol specifies a repeating character in a number format string. The repeating
character completely fills the cell and adjusts if the column width changes. The following format
string, for example, displays the contents of a cell padded on the right with dashes:
General*-;-General*-;General*-;General*-