| 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) | |||
Linear Mode
