I am combining 2 lists in 2 columns in XL. The index in both lists is
in the format: 01-Adams. There is one for each county in the state. I
want to know how to convert the 01 text part to a numeric value to
compare to another one and determine where they should be in a table.
If I do a

strOrigCtyNo = Right(strOrig, Len(strOrig) + 2)

I believe it will give me the first 2 characters of the code. How do I
convert them to an integer constant to compare them, or do I even have
to? If I remember right from my old programming days, comparing numbers
in ASCII sometimes gives different results from comparing numbers. Is
that still true in VBA? What is the best way to proceed here?
Thanks again!