CDHS Object Codes in XL not clean

[davegb]

I imported a list of codes from Word into XL. I then parsed out the
parts I needed to create a table of those codes and their descriptions
to make them easier to use. A couple of MID commands did that fine.

Now, I'm trying to do a vertical lookup, using the code as the
reference to retrieve the description. When I copy the code from the
list and put it in the reference cell, the VLOOKUP works fine. When I
type in the same number, I get a #NA error. This tells me there's some
garbage in there with the codes that is preventing VLOOKUP to
recognize it. I've deleted out extraneous spaces, so that's not the
problem. Any ideas as to what's come in with the data from Word that
would cause this, and how to fix it?

Thanks in advance.

 

[Jim Cone]

Try running the "Clean" function on the data.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"davegb"
wrote in message
I imported a list of codes from Word into XL. I then parsed out the
parts I needed to create a table of those codes and their descriptions
to make them easier to use. A couple of MID commands did that fine.

Now, I'm trying to do a vertical lookup, using the code as the
reference to retrieve the description. When I copy the code from the
list and put it in the reference cell, the VLOOKUP works fine. When I
type in the same number, I get a #NA error. This tells me there's some
garbage in there with the codes that is preventing VLOOKUP to
recognize it. I've deleted out extraneous spaces, so that's not the
problem. Any ideas as to what's come in with the data from Word that
would cause this, and how to fix it?

Thanks in advance.