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.)

--
Kevin Vaughn


"liam" wrote:

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?