Alphanumeric Sorting - numeric alpha numeric

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
 
S

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

Mike

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...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help removing extra TOC text from number lists used as TOC levels 0
Autofill alphanumeric prefix in Excel 3
Remove Text From AlphaNumeric 11
conditional formatting 0
if able, how do you sort Tabs in excel (alpha-numeric) ?? 3
Sorting Alphanumeric data 6
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5
VLOOKUP WITH ALPHA NUMERIC 14

Top