Posted to microsoft.public.excel.programming

external usenet poster

Posts: 60

Query AS400 and unknown character

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wildcard Character Placement in MS Query	DT	Excel Discussion (Misc queries)	0	November 14th 07 10:04 PM
Wildcard character in MS Query	Grd	Excel Discussion (Misc queries)	2	November 5th 07 10:31 PM
UnKnown Character Removal	CyndyG	Excel Worksheet Functions	2	April 28th 05 01:42 AM
Unknown Character removal	Jerrard	Excel Worksheet Functions	3	November 5th 04 10:46 PM
SQL against AS400	R. Choate	Excel Programming	4	November 7th 03 09:11 PM

All times are GMT +1. The time now is 11:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us