Help with sorting texts and numbers in the same column

[edytwinky]

I'm trying to sort many different order numbers on one column. They are as so:

698108
850235
850235
996926
7065682
6T-7881
7G-5444
7G-5445
7I-7728
7I-7728
7W-8791
8E-3603
R518851
R518851

If you notice, the number 6T-7881 is not kept with the 6's in numberical order. It's after the 7065682 number. How can I change it so it goes along with that?

 

[Oaktree]

Welcome to the board.

Try selecting your column, going to data --> text to columns, click next twice, change "Column data format" to Text, and click finish. That will change your numbers to "numbers stored as text".

When you go to sort, you should get a sort warning that says "The following sort key may not sort as expected because it contains some numbers formatted as text:" and ask you what you want to do. Choose the second option ("Sort numbers and numbers stored as text separately").

 

[edytwinky]

Thanks for the welcome!

I gave it a whirl and no dice. Were you able to get it to work? I did not receive the error message. The sort still came through with the numbers first, then the numbers with letters: same as last time.

 

[Scott Huish]

Worked for me.

Here are the results after sorting:

Book2
	A	B	C	D
1	698108
2	6T-7881
3	7065682
4	7G-5444
5	7G-5445
6	7I-7728
7	7I-7728
8	7W-8791
9	850235
10	850235
11	8E-3603
12	996926
13	R518851
14	R518851
Sheet1

Are you sure you followed all Oaktree's directions?