"Neal Zimm" wrote in message
...

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


Hi Neal,

I may be missing something here, but why not just use the:

Edit - Fill - Justify

functionality?

If you need to do it in VBA, then something like:

Range("A1:A10").justify


HTH,

Alan.