Text Truncated in Excel Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Despite upgrading to SP1 and experimenting with putting quotes around and removing quotes from around about 250 words of text in a cell, the text as displayed by Excel is truncated. The CSV source file is correct by inspection. I cannot find a published limit on text in a cell. What is the story?
 
Hi William!

Do a search in Help on "Specification"

You'll find

Column width: 255 characters
Length of cell contents (text): 32,767 characters. Only 1,024 display
in a cell; all 32,767 display in the formula bar
Length of Formula content: 1,024 characters

You can use wrapping of the text with vertical alignment at top to see
more (with increased row height).

To investigate number of characters imported you might use:

=LEN(A1)
 
Back
Top