AHMTD,

For a list starting in cell A1, and extending down column A, you will need
two helper columns. In cell B1, use the formula

=LEN(A1)

In cell C1, use the formula

=LEFT(A1,1)

and copy both those cells down to match your list.

Then select all three columns, and sort first based on Col B Ascending, then
Col C Ascending, and finally, Col A ascending.

HTH,
Bernie
MS Excel MVP


"AHMTD" wrote in message
...
How do I sort a text column which includes A to Z then AA to AZ then BA to
BZ
...