I have value like

abc1
abc2
abc10
abc100
bcd5
abcd1
abcd2
abc3
zbc1
xyz1

how can i sort it so that both text value and numeric value will be sorted. So that i will get the result like:

abc1
abc2
abc3
abc10
abc100
abcd1
abcd2
bcd5
xyz1
zbc1

I.e. i want both alpha value and numeric value will be sorted.