Sorting 2 alphanumeric columns using macro - considers only first 4 byte of column

Hello,
I want to sort data based on first 2 columns(i.e. 1st column is primary key and 2nd column is secondary key). Column is alphanumeric field(will have combined value of alphabets and numeric).
My macro(below mentioned) is partially(it considers only first 4 byte of column)
working
----------------------------------
Sub SORT()
Cells.Select
Selection.SORT Key1:=Range("A2"), Order1:=xlAscending, Key2:=Range("B2") _
, Order2:=xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2 _
:=xlSortNormal
Range("A2").Select
End Sub
----------------------------------
Questions:
1. why it is not considering rest of data in column.(PFA data sample)

Can you help me on this

It is sorting like below
EN02
EN10
EN10
EN10
EN10
EN1111
EN123
EN171
EN22
EN3333
EN55
EN554
EN565

But it is supposed to be like below
EN02
EN10
EN10
EN10
EN10
EN22
EN55
EN123
EN171
EN554
EN565
EN1111
EN3333

Thanks for the suggestion.