Cell Character Limitations In Excel 2000

I understand Microsoft Excel 2000 has a 35K character
limitation, but only 1K characters appear in a cell. Does
anyone know of a way to get around this limitation? VB
for Applications? If VBA is the way to go, can some share
the code? Thanks!

Hi
what you can do to extend the 1024 characters limit in a cell is
manually entering linebreaks with ALT+ENTER. No way arounf the 32K
limit

--
Regards
Frank Kabel
Frankfurt, Germany

"Jason M. Perretta MCSE CCNA MOS (Outlook & Access 2000) A+ Net+"
schrieb im Newsbeitrag
...
I understand Microsoft Excel 2000 has a 35K character
limitation, but only 1K characters appear in a cell. Does
anyone know of a way to get around this limitation? VB
for Applications? If VBA is the way to go, can some share
the code? Thanks!

VBA may be even less helpful. There's limit as to the number of characters
that can be passed between a worksheet and VBA. In working out some recent
issues with the COMPARE.XLA utility, there were problems when a formula
exceeded (AIR) 903 characters.


On Fri, 27 Aug 2004 11:46:39 -0700, "Jason M. Perretta MCSE CCNA MOS \(Outlook
& Access 2000\) A+ Net+" wrote:

I understand Microsoft Excel 2000 has a 35K character
limitation, but only 1K characters appear in a cell. Does
anyone know of a way to get around this limitation? VB
for Applications? If VBA is the way to go, can some share
the code? Thanks!