Excel version?

In 2003, highlight the data you want to sort and go to Data Sort.
Click "Options" and choose "Sort left to right".

--JP



On Oct 14, 7:44*am, Nigel Molesworth
wrote:
I've got an Excel file with a column holding text data such as:

[B11], [B1], [A2], [B100], [B010], [A1] * - * where [] is the cell

which I want to sort as:

[A1], [A2], [B1], [B010], [B11], [B100]

Note that the leading zeroes (as in [B010], which equals [B10]) are not
required, so I could happily lose them before sorting.

Any suggestions on how to do this?