Excel 2007 Sorting

Hello,

I have imported a document into excel as text an trying to sort a column. For example, I have aa1,aa6,aa10,aa25,aa2,aa11. I would like them to be sorted as aa1,aa2,aa6,aa10,aa11,aa25, but it keeps sorting like aa1,aa10,aa11,aa2,aa25,aa6. How do I get it to sort the way I would like. I’m new to VBE and SQL so please bear with me. Gotten some tips on codes but don’t understand how to write them in.

Thanks