If the cell does actually contain a formula (a formula starts with the = character), not a
number or text, then the formula length limit applies. I couldn't find formula length limit
in the Limits and Specifications part of Help, but it was 1024 characters in Excel 2000.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
wrote in message
ups.com...
Even in the formula bar the entire text is not displayed. I know
there is no problem with the data dump itself because when I try to
type more characters in the formula bar I get an error saying that the
formula is too long. Any ideas?