Want to sort the column first by alphabetically and then numerically

Want to sort the column first by alphabetically and then numerically

yashwant.dhakadyashwant.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:

Answers

Sign In or Register to comment.