Alphanumeric Sorting - numeric alpha numeric

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I'm hoping someone can help me out. I've looked all over for a solution to
my sorting in excel. I've seen sorting with alpha numeric where it starts
with a number and ends with an alpha or opposite that. What I need is
something that sorts by numeric alpha then numeric again. The fields change
in size such as:
###A# or ##A###. I need it to sort by the first set up numbers then by the
Alpha then by the last set of numbers.

Thx
 
Pl. see the post "Separate Text into numbers and alphabets" which I had
posted for the solution.

Use that to separate your values into three columns and then Sort on these
three columns in order...
 
Worked Great Thanks!

Sheeloo said:
Pl. see the post "Separate Text into numbers and alphabets" which I had
posted for the solution.

Use that to separate your values into three columns and then Sort on these
three columns in order...
 
Back
Top