sorting

[eurozeus]

I'm triying to sort letters and numbers together like ch5600,ch74110 and so on
but when I try it doesn't sort in scending sequence
ch441
ch445
ch5416
ch5419
ch5429
ch5689
ch74110
ch76129
ch7848
ch7895
ch878
ch8833
ch8965

ch878 should be after ch445
and ch74110 and ch76129 should be the last numbers can you helpme wih this
please (1 COLUMN)

THANK YOU!

 

[Max]

One way is to sort by a helper col
Assuming source data as posted in A1 down
Place in B1, copy down: =MID(A1,SEARCH("ch",A1)+2,99)+0
Then select cols A & B, sort by col B > Ascending > OK