Microsoft Excel

I AM TRYING TO CHANGE THE SORT FROM NUMERIC/ ALPHA TO ALPHA NUMERIC

I HAVE PART NUMBERS WITH MIXED NUMBER AND LETTERS

IT CURRENTLY SORTS

0123456789 ABCD...

I NEED ABCD ... 0123456789

HOW DO I ACCOMPLISH THIS