Alphanumeric Sorting - numeric alpha numeric

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

"Mike" wrote:

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

Worked Great Thanks!

"Sheeloo" wrote:

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" wrote:

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