Sort numbers alphabetically

P

Pungh0Li0

Let's say I have a list:
1
2
5
20
35

I want it alphabetical, ie:
1
2
20
35
5

Even if I make them text, they still sort numerically.
Is there some trick?

Thanks, Joe
 
G

Gord Dibben

One method................

In B1 enter =LEFT(A1)

Copy down.

Copy and paste special>values.

Select column A and B and sort on column B


Gord Dibben MS Excel MVP
 
P

Pungh0Li0

Well, maybe I made my example too simple.
More realistic is a long list such as:
1219760
5001057
5002280
17031590
17031591
170039110
35S0409
7631-0001-0002
etc

I want to sort alphabetically, as if this were all text.
Some may even include letters and dashes.

Thanks, Joe
 
K

Ken Johnson

Well, maybe I made my example too simple.
More realistic is a long list such as:
1219760
5001057
5002280
17031590
17031591
170039110
35S0409
7631-0001-0002
etc

I want to sort alphabetically, as if this were all text.
Some may even include letters and dashes.

Thanks, Joe
Click to expand...

Similar to Gord's except use ="A"&A1 in B1.
Nothing special about "A". Prefacing with any character seems to work.
Ken Johnson
 
P

Pungh0Li0

Similar to Gord's except use ="A"&A1 in B1.
Nothing special about "A". Prefacing with any character seems to work.
Ken Johnson
Click to expand...

Yep, that works!
Strange that it doesn't give you the option to sort alphabetically
when you format the cells as Text.

Thanks a lot, Joe
 
Top