Alphanumeric Sorting - numeric alpha numeric

[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

 

[Sheeloo]

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...

 

[Mike]

Worked Great Thanks!

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...