Issue with Text being cut off

[BrianP1]

I have a pivot that has a field with very long text. The text is all there in the pivot however when I do a VLOOKUP against the Pivot, that field's data keeps getting cut off. Any idea how I fix this so that the full text shows up?

 

[MUKESHY12390]

that field's data keeps getting cut off. Any idea how I fix this so that the full text shows up?

did check length by using len() formula?

what is maximum length of that "Very long text" ??

 

[BrianP1]

did check length by using len() formula?

what is maximum length of that "Very long text" ??

one example is 1883 characters long

 

[MUKESHY12390]

let me tell you , as far I know Vlookup has limit for lookup value and it is 255 CHAR , If use any char beyond 255 let's say 256 you will get error in Vlookup.

 

[jtakw]

Hi,

I can't replicate your problem, I tested with some dummy data with 8000 characters in the cells, and used VLOOKUP, the results returned correctly, there's something else causing your incorrect results.
Can't help unless you post a link to a sample file here from a free file hosting site like Dropbox.

@MUKESHY, the 255 character limit is the Column Width limit, maximum number of characters within a single cell is 32,767