Thread
:
Fill blank cells with spaces
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
Posts: n/a
Fill blank cells with spaces
wrote...
I was wondering if there's somehow I can fill n char width cells with
spaces.
i.e. If I have a blank cell with width "8", it will be filled with 8
spaces. It'd be something like format cells with "00000000", but with
spaces instead of zeros.
Is this for the contents or what Excel displays? If the latter, you
could use Fill horizontal alignment and a monospace typeface.
Reply With Quote