vlookup truncating information

  • Thread starter Thread starter liam
  • Start date Start date
L

liam

vlookup is truncating information that im trying to bring into a new
spreadsheet. I think its reducing it to 255 characters. Is there a way
of changing this or switching it off?
 
Which version of Excel are you using? I just now tried it with 2000. First
I entered text in a cell and tested it with the len function. It was 384
characters. Then I did a vlookup both in the same spreadsheet, and from a
different workbook. In both instances, I was able to see the entire contents
of the cell (after expanding the width and turning wrap text on.)
 
If you open the "sending" workbook and then recalculate, you'll see all the
characters. But if that "sending" workbook is closed, your data will be
truncated at 255 (or 256???) characters.
 
Back
Top