Hi there,

I need to sort by lowest to highest cells that have either just a number inside or a number and a letter.

As an example:

100
101
102
100A
101B
102C

I want this to look like:

100
100A
101
101B
102
102C

Regular sorting in excel would give me the numerical values first and then the values with numbers and letters second. Anyway I can change the sorting option so it looks only at numbers and ignores all letters?

Thanks