Hi Brian,
interesting because Excel uses it's own collating sequence and the
underscores would sort before numbers and letters as long as the
cell is not a number. Anyway a problem with the original data from
the web is that you are not going to see all characters. I would suggest
that you copy from the web page, then use data, text to columns
separating on a space, tab and all that with two spaces same as one space.
Then the important part, run the TRIMALL macro as found in
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

I tested with the data you posted (copied from my page) and it
got almost the same results as you describe (except for first column).
Removing the blanks to start over, running the TrimALL macro and it
ran fine.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message oups.com...
Lightbulb: I just changed the value of too_high to equal "___" instead
of "ZZZZZZZZ" and it works like a charm...