You'll have to separate the numbers into a different column.

If all the letters are exactly two digits, you could use:
=--mid(a1,3,255)

(the -- converts the text that =mid() produces to a real number.)

Then you can sort your data by using this helper column.

George wrote:

How to sort ignoring letters, Excel 2003
ny only containing numbers,
For example
default sorting wanted sorting
AA101 AC02
AB99 AB99
AC02 AA101
Thanks
George

--

Dave Peterson