How can I advanced sort into a Collum
Well, why not separate out the two characters you need, i.e. enter:
= LEFT(B1,2)
in cell C1 and copy down. Now sort your data (plus column C) using
column C - you can always delete this column if you have no further
need for it.
Hope this helps.
Pete
|