Sort numbers alphabetically

  • Thread starter Thread starter Pungh0Li0
  • Start date Start date
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
 
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
 
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
 
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
 
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
 
Back
Top