N
Neal Zimm
In my application, printing a route delivery 'book', I form character
strings made up of numerals, special characters such as parentheses and
brackets, and uppercase letter text in Arial font, size 20. (I would rather
NOT use a non proportional font such as Courier). The font size IS needed
for readability. The strings can range from 4 to 20 or 30 characters.
It's important that the entire string shows and is not 'view truncated' by
the contents of the cell to the right of the one holding the string. Is there
some table to look up character widths, or some other method by which I can
calculate the 'width' of the character string to compare it to the column
width which is 27. I can break up the character string if it's too long and
put some of it in the next row.
(the default font for the worksheet is Arial, size 10.)
Visual inspection of the affected cells , after the fact, is not really
feasible. I am looking for a way to calculate the width of the string, and
then use from 1 to ??
rows to hold what has to be read by the delivery staff.
Thanks,
Neal Z
strings made up of numerals, special characters such as parentheses and
brackets, and uppercase letter text in Arial font, size 20. (I would rather
NOT use a non proportional font such as Courier). The font size IS needed
for readability. The strings can range from 4 to 20 or 30 characters.
It's important that the entire string shows and is not 'view truncated' by
the contents of the cell to the right of the one holding the string. Is there
some table to look up character widths, or some other method by which I can
calculate the 'width' of the character string to compare it to the column
width which is 27. I can break up the character string if it's too long and
put some of it in the next row.
(the default font for the worksheet is Arial, size 10.)
Visual inspection of the affected cells , after the fact, is not really
feasible. I am looking for a way to calculate the width of the string, and
then use from 1 to ??
rows to hold what has to be read by the delivery staff.
Thanks,
Neal Z