View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 255 Character Limit

If you're using =vlookup() to return a value from a closed workbook, then open
that other workbook (and force a recalculation).

Closed workbooks will only "send" 255 characters.


Colin wrote:

I am doing a vlookup command and am it is only returning the first 255
characters. How can I make it return them all?


--

Dave Peterson