Hi

why in power query when I try to sort based on numbers its give me mistake result
example,
cell 1 = A 29
cell 2 = A 201
cell 3 = A 200

Sorting A-Z give this result
A 200
A 201
A 29

I know excel read it as one letter and number by one, but how to solve this?