Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLookup accesses half the text in a field?
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? |
#2
|
|||
|
|||
hi
the max is IMHO 255 characters if the other file is closed -- Regards Frank Kabel Frankfurt, Germany "CIDERIE" schrieb im Newsbeitrag ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
How can I import a text file into excel with each field as a sepe. | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |