Issues with sorting on text fields that contain numbers

Actually I should have suggested just creating another column which strips the letters, so 3a becomes 3 that way you can sort on that number column and display your non-padded number

Assuming you don’t mind too much if 3a comes before or after 3 etc…