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

Alphanumeric Sorting - numeric alpha numeric
 

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

Alphanumeric Sorting - numeric alpha numeric
 

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