Sorting Letters and numbers, and the 10 before 2 problem!

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hi Guys,

I have a column with data such as A1, A2 etc to A12 then B1,B2 to B12, you get the picture. Because of other data in the *** it is entered out of sequence but i would like the option to see it in sequence.

When i use autofilter i get A1, A10, A11, A12, A2 etc. How can i make it read A1, A2 and so on? I can enter that data in a different format if that would make it work.

Thanx in advance for any help
.

Loading