sort "numbers" with decimals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got chapter numbers in one column which goes: 4.1, 4.2, 4.3...., 4.11,
4.12....
How can I sort it by the numbers on the right of the decimal point instead
of getting: 4.1, 4.10, 4.11, 4.12, ....4.2, 4.20, 4.21, ....
 
Insert two Columns at the right of the numbers.
Select the range of numbers i.e. "A:A"
Then go to DATA>> Text to Columns >> Delimited
Uncheck all checked and then select "Other and put a "." in the spac
provided (without the "")
Then Click Finish.
You'll have on B:B all the data before the point.
In Colum C Row 1 you can put =A1&"."&B1 to get the numbers togethe
again.

Saludos

NlC
 
you need to split the values first and then sort by the decimals

to split them use <data> <text to columns> <delimited> <other> .
<destination> next to your chapter numbers.
then sort by the column with the decimals

have fu
 
Another option would be to use:

4.01, 4.02, ...

(or 4.001, 4.002, ... if you can hit triple digits)
 
Back
Top