Kevin,

In the column next to the one you want sorted. Use this formula: =Left(A1,4)

This will return the first four numbers and this column, simple sort the
columns as normal based on the second column.

Hope this helps,
Teri

"Kevin" wrote:

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