+ Reply to Thread
Results 1 to 5 of 5

Fitting characters of a font size in a cell width

  1. #1
    Neal Zimm
    Guest

    Fitting characters of a font size in a cell width

    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






    --
    Neal Z

  2. #2
    Alan
    Guest

    Re: Fitting characters of a font size in a cell width

    "Neal Zimm" <nealzimm@yahoo.com> wrote in message
    news:23A41339-5691-4846-BFD4-8F7E665721C8@microsoft.com...
    >
    > 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.



  3. #3
    Neal Zimm
    Guest

    Re: Fitting characters of a font size in a cell width

    I'll try it, but I was not complete in my explanation. A row in the book has
    only 3 columns, each with a width of 27. Each column has a specific meaning
    and usually 1 row is enough to hold the needed info. The oddball, tho
    important, situation is where more than one row is needed to hold the data,
    which must remain at font size 20 for easy readability. I'll try your
    solution. Thanks.

    --
    Neal Z


    "Alan" wrote:

    > "Neal Zimm" <nealzimm@yahoo.com> wrote in message
    > news:23A41339-5691-4846-BFD4-8F7E665721C8@microsoft.com...
    > >
    > > 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.
    >
    >
    >


  4. #4
    NickHK
    Guest

    Re: Fitting characters of a font size in a cell width

    Neal,
    Can you not WrapText and make the row taller ?

    NickHK

    "Neal Zimm" <nealzimm@yahoo.com> wrote in message
    news:64AC2821-6E29-419B-A025-4B88AB7BDB21@microsoft.com...
    > I'll try it, but I was not complete in my explanation. A row in the book

    has
    > only 3 columns, each with a width of 27. Each column has a specific

    meaning
    > and usually 1 row is enough to hold the needed info. The oddball, tho
    > important, situation is where more than one row is needed to hold the

    data,
    > which must remain at font size 20 for easy readability. I'll try your
    > solution. Thanks.
    >
    > --
    > Neal Z
    >
    >
    > "Alan" wrote:
    >
    > > "Neal Zimm" <nealzimm@yahoo.com> wrote in message
    > > news:23A41339-5691-4846-BFD4-8F7E665721C8@microsoft.com...
    > > >
    > > > 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.
    > >
    > >
    > >




  5. #5
    Neal Zimm
    Guest

    Re: Fitting characters of a font size in a cell width

    Not really. The route books are used in the middle of the night in a
    semi-dark car.
    The 'look' has to be consistant. I know I'm getting kind of nit-picky here,
    but I may have to settle for a standard mix of characters, and if the count
    is more than 12 or 13, split the text into different rows.
    --
    Neal Z


    "NickHK" wrote:

    > Neal,
    > Can you not WrapText and make the row taller ?
    >
    > NickHK
    >
    > "Neal Zimm" <nealzimm@yahoo.com> wrote in message
    > news:64AC2821-6E29-419B-A025-4B88AB7BDB21@microsoft.com...
    > > I'll try it, but I was not complete in my explanation. A row in the book

    > has
    > > only 3 columns, each with a width of 27. Each column has a specific

    > meaning
    > > and usually 1 row is enough to hold the needed info. The oddball, tho
    > > important, situation is where more than one row is needed to hold the

    > data,
    > > which must remain at font size 20 for easy readability. I'll try your
    > > solution. Thanks.
    > >
    > > --
    > > Neal Z
    > >
    > >
    > > "Alan" wrote:
    > >
    > > > "Neal Zimm" <nealzimm@yahoo.com> wrote in message
    > > > news:23A41339-5691-4846-BFD4-8F7E665721C8@microsoft.com...
    > > > >
    > > > > 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.
    > > >
    > > >
    > > >

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1