How do I filter a number list by numbers to the right of the decim

[louannes]

I need to sort a list of numbers (and their values) by the numbers to the
right of the decimal, i.e., the list has numerous values to the left (whole
numbers), but the right have only 4 or 5 and I need these segregated by the
decimals to the right in order to put them in columns. From: 600000.3019
50
600000.3030
125
600000.6000
60
602000.3019
100
602000.3030
25
602000.6000
85
To:
600000.3019 50 600000.3030 125 600000.6000 60
602000.3019 100 602000.3030 25 602000.6000 85

 

[CLR]

You can use a helper column, if your data is in column A, put this in B1 and
copy down........
=MID(A1,FIND(".",A1,1)+1,99)

then do Copy > PasteSpecial > Values on column B to get rid of the
formulas........
Then do Data > TextToColumns, and use SPACE as the delimiter to separate the
isolated digits in each number to their own column C
Then, do Data > Sort > using column B as the first key and column C as the
second key........

Vaya con Dios,
Chuck, CABGx3

I need to sort a list of numbers (and their values) by the numbers to the
right of the decimal, i.e., the list has numerous values to the left (whole
numbers), but the right have only 4 or 5 and I need these segregated by the
decimals to the right in order to put them in columns. From: 600000.3019
50
600000.3030
125
600000.6000
60
602000.3019
100
602000.3030
25
602000.6000
85
To:
600000.3019 50 600000.3030 125 600000.6000 60
602000.3019 100 602000.3030 25 602000.6000

85

 

[Ragdyer]

I think that TTC can handle the entire job.

Select the column, then <Data> <TTC>, click "Delimited", then <Next>.
Click <Space> and <Other> and enter a "Period" in the Box, then <Next>.
Click "Do Not Import Column",
Then change the address in the "Destination" box to an adjoining column
(maybe B1), so that the original data remains untouched.
Then <Finish>

Now, select all 3 columns, and sort on B first, then C.

You can now delete Column B and C.