The other solution is the more correct solution. Your solution
with concatenation is really only valid if each part in the concatenation
has a consistent length. Consider the following list. Correctly in sequence.
AA B
AA BC
AAA B
Sorting the concatenation could produce incorrect results as in:
AAAB
AAB
AABC
---
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