How can you get Excel to sort numbers with alpha suffixes? 1234A

B

boneified5

How can you get Excel to sort numbers with alpha suffixes? Example: 1234A
I need to have Excel sort numericaly and not put the numbers with alpha
characters at the bottom but keep them in order like this: 1234 1234A
1234B 1235.
Thanks for any help.
 
B

Bernard Liengme

Sounds like you need 'helper columns' with something like
=LEFT(A1,4) in one and RIGHT(A1.1) in another
The sort using the first and second columns as the 'keys'
When done, you can delete the helpers
best wishes
 

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

How do I sort alpha neumeric fields that have an alpha suffix? 2
Sorting Numbers w/Aplha Suffix 5
How do I sort alpha neumeric fields that have an alpha suffix? 3
Sorting 2
Creating a drop box or Dlook up 2
Sorting number combinations 9
What is this called in Excel or how it works? 0
Sort Criteria 1

Top