Great, that works for column 'A', is it possible to use this somehow to
clean column 'B' during the query process and just eliminate the need for
column 'A' ?

D.S.

"Paul Robinson" wrote in message
om...
Hi,
Try

Application.worksheetfunctions.Clean(Trim(QueryVal ue))

The Clean removes non printing characters and the Trim leading or trailing
spaces.

regards
Paul

"D.S." wrote in message
...
I'm using Excel to query an AS400 library file. The query is returning
a
combination of numerical and alpha-numerical values. When I use VLookup
to
find specific data that was returned by the query, the VLookup does not
recognize the values as they "appear" to be. There is apparently an
additional character in the value that is not apparent. I've tried
searching the data for the infamous Alt-0160 character, but I'm not
finding
that. Any ideas as to what's going on, or how to compensate for it?

D.S.