Want to sort the column first by alphabetically and then numerically
Want to sort the column first by alphabetically and then numerically
yashwant.dhakad
Posts: 3Questions: 2Answers: 0
Hello,
I have the column values in this format
91-0758-1
9430994
950-348-1
A102-29E
A102-2D
A103DP
B-7669B
COFFEE MUG
CP478
DAA05236-01
M25988/1-138
NAS1836-3-16
NAS509-4
and want to sort them in alphabetically first then numerically like this format:
A102-29E
A102-2D
A103DP
B-7669B
COFFEE MUG
CP478
DAA05236-01
M25988/1-138
NAS1836-3-16
NAS509-4
91-0758-1
9430994
950-348-1
Can some one help me on this?
This question has accepted answers - jump to:
This discussion has been closed.
Answers
i've used the Natural Plugin to sort similar types of data.
Kevin
This plug-in should do the business.
Allan
Thanks, Allan and Kthorngren.