I have a column that run

1a
2a
3a. etc.


The problem is when I sort a-z the 10a comes before 1a. Is there a macro to set that. I did the custom sort but it only reaches till 8a going 1a, 1b, 1c and it runs out of space. A
ny help appreciated

AUTOINSERTION.xlsx