hi guys,
i have a lots of data in the same column,
and i wanna sort them in specific order
for example
A
A12
B
B23
C
D
E
F12
G
H
I
J1234
and the expected sorting order is :
D
E
F
F12
A
A12
......
in specifically, i have dynamic numbers behind the text.. may be added one day, and i cant set up a sorting just by adding the custom sorting in excel.
Any thoughts on this sorting?
Happy Weekend!
Bookmarks