How to do an alpha numeric Sort By?

Opul3nce · #1 10-15-2012, 03:00 PM

Hello,
First and foremost,
I'm new here and would like to say thank you beforehand for any assistance you give.

Here is the problem I've got.

I export DOORS requirements to excel 2007,

The requirements are described as

Code:

 
TEST-1
TEST-34
TEST-24
TEST-100

etc.

When using Excels default A->Z 'sort by' feature I get

Code:

 
TEST-1
TEST-100
TEST-24
TEST-34

Needless to say what I actually want is

Code:

 
TEST-1
TEST-24
TEST-34
TEST-100

I find it interesting that I can type

Code:

 
TEST-1
TEST-2

Then highlight and click and drag to get TEST-1 all the way to TEST-X, yet I can't sort by this way, or at least I don't know how.

Again, Many Thanks!

Pecoflyer · #2 10-15-2012, 11:11 PM

I think the easiest way is to use a helper column containing

Code:

=MID(A1,6,LEN(A1)-5)*1

( dragged down) which will give you a column containing the numbers then sort the range by that column. You can eventually hide this helper column

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unique 3 char Alpha Numberic column	mauricioaglr	Excel	7	03-09-2012 06:45 PM
alt+numeric doesn't work	Kungen	Word	3	12-02-2011 11:25 AM
Word 2007 TOC Section Number w/Alpha Prefix?	Gwen Butler	Office	2	09-29-2011 06:10 AM
Place pages in alpha order.	Wskip49	Word	5	08-28-2011 07:54 PM
[How To] Generate Alpha Numeric Values in Excel 2010	stnicholas81	Excel	1	07-25-2011 01:31 AM