Hi rivergirl,
Expect you want to to sort like in the sort order that you would
see on mainframes which use EBCDIC instead of ASCII
http://www.mvps.org/dmcritchie/excel/sorting.htm#ebcdic
and are talking strictly about text cell values. The macro
populates a helper column for you to sort.
---
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