View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Larry Larry is offline
external usenet poster
 
Posts: 159
Default how do I calculate number of characters that will fit in a cell

I have a spreadsheet that will be printed onto a preprinted form. I need to
calculate the value in a cell and then pad that cell with repeating hyphens
to fille out the remainder.

How can I determine how many hyphens I need to generate?