Is it possible to sort a column by first number then text? I have an ID column with the following data:
CE01
FE05
112
24
DE4
98
Is there any way to sort by first integer then character to give:
24
98
112
CE01
DE4
FE05
Obviously character sorting only will result in 112 being the first row, 24, then 98 etc.
Thanks,
Daniel.
CE01
FE05
112
24
DE4
98
Is there any way to sort by first integer then character to give:
24
98
112
CE01
DE4
FE05
Obviously character sorting only will result in 112 being the first row, 24, then 98 etc.
Thanks,
Daniel.