+ Reply to Thread
Results 1 to 5 of 5

Wrapping Text in a cell limitations - Excel 2003

  1. #1
    FLHOIT
    Guest

    Wrapping Text in a cell limitations - Excel 2003

    When wrapping text in a cell (Excel 2003), does the wrapping only apply to a
    limited amount of characters? I notice the wrapping stops after a certain
    point. Is there a work around?


  2. #2
    Forum Contributor
    Join Date
    01-06-2004
    Location
    Carbondale CO
    Posts
    245
    FLHOIT,
    If you type in "Excel specifications and limits" into help and look for "Length of cell contents" you might see where your problem is at.
    For my version 2002 it reads:
    Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

    HTH
    Casey

  3. #3
    Tom Ogilvy
    Guest

    Re: Wrapping Text in a cell limitations - Excel 2003

    It stops around 1024 characters. You can overcome it by doing Alt+Enter
    periodically within the data.

    --
    Regards,
    Tom Ogilvy

    "FLHOIT" <[email protected]> wrote in message
    news:[email protected]...
    > When wrapping text in a cell (Excel 2003), does the wrapping only apply to

    a
    > limited amount of characters? I notice the wrapping stops after a certain
    > point. Is there a work around?
    >




  4. #4
    Tom Ogilvy
    Guest

    Re: Wrapping Text in a cell limitations - Excel 2003

    That's true, but if you use what I posted, you can exceed 1024.

    --
    Regards,
    Tom Ogilvy


    "Casey" <[email protected]> wrote in
    message news:[email protected]...
    >
    > FLHOIT,
    > If you type in "Excel specifications and limits" into help and look for
    > "Length of cell contents" you might see where your problem is at.
    > For my version 2002 it reads:
    > Length of cell contents (text) 32,767 characters. Only 1,024 display in
    > a cell; all 32,767 display in the formula bar.
    >
    > HTH
    >
    >
    > --
    > Casey
    >
    >
    > ------------------------------------------------------------------------
    > Casey's Profile:

    http://www.excelforum.com/member.php...fo&userid=4545
    > View this thread: http://www.excelforum.com/showthread...hreadid=477635
    >




  5. #5
    Forum Contributor
    Join Date
    01-06-2004
    Location
    Carbondale CO
    Posts
    245
    Tom,
    Thanks for the additional info. I have used alt>enter alot for formatting reasons, I did not know you could circumvent the 1024 limit by using it. I occasionally need that many characters in cell and always ended up splitting the information between cells.

+ 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