If you're retrieving a value from a closed file, then that's how excel works.

If you want to see the complete string, open the "sending" file.

Gisela wrote:

I'm retrieving a text field using the vlookup function. The formula works but
it does not display all the characters of the text. How can I fix the
problem? Does the vlookup have any limitation? Please, help!

--

Dave Peterson