General sort question

[ipbr21054]

I have a list of motorcycle model on a worksheet.
I sort them A-Z

In the list are various models that are slightly difference,see example below.

CB 1200
CB 500
CB 600
CB 900

Also
VFR 1200
VR8 800

It sorts the A-Z correctly but why does 1200 come before the lower value numbers ?

 

[mole999]

the simple answer is 1 is less than 5, as it is CB makes it a text string so it is purely that, it knows nothing about number sizes

 

[GraH]

This sort order is A-Z like, so numbers "0" to "9" are seen as text, reading left to right. "1" is for "2" even if it is 100 and 20.

 

[ipbr21054]

Thanks,
Ive read both.

Is there a code we can use to sort it how i need it or is that not possible & just put up with it.

Im thinking as this list od models become bigger 1200 1400 etc will be at the start & im sure the staff will be looking at the edn

Thank

 

[GraH]

How would you sort (see red number)?
VFR 1200
VR8 800

You can extract both parts and sort them accordingly
EDIT:

Book1
	A	B	C
1	CB 500	CB	500
2	CB 600	CB	600
3	CB 900	CB	900
4	CB 1200	CB	1200
5	VFR 1200	VFR	1200
6	VR8 800	VR8	800
Sheet1

Cell Formulas
Range	Formula
B1:B6	B1	=LEFT(A1,FIND(" ",A1)-1)
C1:C6	C1	=MID(A1,LEN(B1)+1,255)+0

 

[ipbr21054]

Sorry my typo

VFR 800
VFR 1200