I have the following list of text entries (that appear to be both numbers and
text, but the cells are all formatted as text) that I need to sort in
numerical order from left to right. I can't find a sort option that let's me
do this - can anyone help? Thanks!

3230
5109
6039
51282
1407D
3234H
4108A
4512H