No way to increase the 1024 limit without inserting an Alt + Enter linefeed
every 100 or so characters.

Use a Textbox for long strings that will be over the 1024 limit.


Gord Dibben MS Excel MVP


On Thu, 19 Nov 2009 08:25:02 -0800, keenah
wrote:

11.19.09

thanks luke m! actually, i realized that i typed the wrong # right after i
clicked the submit button, then it was alredy too late & couldnt figure out
how to get back to it. i tried searching for the post but it was almost an
impossible task. then when i finally figured out a way to find it, i
realized i could not edit it. by the time i found it you had already
replied. i apologize for my mistake.

1. thanks for the clarification however my question still remains. is there
a way to increase the char limit from whatever the amount is or perhaps make
it unlimited to avoid the conflict?

2. (new) also, is there a way to avoid having to hit Alt|Enter in order for
the characters above the display limit (1,024) to show & printed whatever the
case might be? not all workstations or printers have the same settings; this
will affect the workstation's display ability to show the file as well as the
printer's settings to print as the author intended it to be displayed or
printed.

it is always a problem when u distribute a spreadsheet & users need to
actually see the contents and|or print it. not all come come out or print
the whole content of the cell with the additional characters, this can be
pretty annoying and a waste of time for the users as well as the file's
author.

thx so much for any help on either or both of these above!




"Luke M" wrote:

The actual limit is 32,767 characters. Of this, only 1,024 will display in a
cell.
(info from "Excel specifications and limits" in XL help file)

Due note that when you set the format of a cell to text, this is when the
256 limit kicks in. Simply change the formatting of the cell to "General" and
then you'll be good to go.

Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*




"keenah" wrote:
11.19.09

can the character limit on an excel cell be increased? there is a standard
set up limit of 32,767 characters. depending on what ur workling on some
times even that is too little amount. is there a way where we can access the
code that determines this limit and change it to elimitate this problem?

please help?

thx so much