G
Guest
Hi!
Does anyone know why Excel fails to wrap text within a cell if the text is
quite long (I suspect this happens when text exceeds the obligatory @#$@%!
255 characters per cell), i.e., it starts out wrapping it and then just hides
the "excess" text without expanding the cell or bothering to wrap the rest of
the text?
Is there ANY way around this superbly frustrating limitation?
It is vitally important for us to work with Excel due to its text functions
and intelligent text/data searching and management. We are dealing with some
EXTREMELY reluctant key users/players who just can't see these advantages and
would be rather stick with using good old Word for the rest of their lives -
because they are not the ones who have to painstakingly make every single
minute change to about 178 places and files every time there is a change (and
there are about 100 of these changes every time there is a revision, which
are to be replicated in an exponentially increasing number of files).
Bottom line: it's CRUCIAL for us to convince these key players in the merits
of using Excel, but the program does not lend itself to be a very easy case
to present due to hiccups like this.
Would very much appreciate anyone's advice.
thx in advance!
Does anyone know why Excel fails to wrap text within a cell if the text is
quite long (I suspect this happens when text exceeds the obligatory @#$@%!
255 characters per cell), i.e., it starts out wrapping it and then just hides
the "excess" text without expanding the cell or bothering to wrap the rest of
the text?
Is there ANY way around this superbly frustrating limitation?
It is vitally important for us to work with Excel due to its text functions
and intelligent text/data searching and management. We are dealing with some
EXTREMELY reluctant key users/players who just can't see these advantages and
would be rather stick with using good old Word for the rest of their lives -
because they are not the ones who have to painstakingly make every single
minute change to about 178 places and files every time there is a change (and
there are about 100 of these changes every time there is a revision, which
are to be replicated in an exponentially increasing number of files).
Bottom line: it's CRUCIAL for us to convince these key players in the merits
of using Excel, but the program does not lend itself to be a very easy case
to present due to hiccups like this.
Would very much appreciate anyone's advice.
thx in advance!