VLookup accesses half the text in a field?

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

Guest

I have specifications in one file and results in another.
When the results file looks up data in the specifications file only half the
text in a long filed is displayed when the source is inactive. If I load the
source file at the same time then all the data is displayed. is this a
"feature" of excel 2003 it never happened in excel 97?
 
hi
the max is IMHO 255 characters if the other file is closed
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dates in VLOOKUP 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VLOOKUP 1
Which is the best MBOX Converter Tool different formats conversion? 4
Merging Excel Sheet with Excel Sheet (Just like in MS Word!) 3
How do I round time down to the nearest half hour? 3
Character limit when retrieving indirect text from external sheet 3
Display text source in multiple sheets 1

Back
Top