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

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



"louannes" wrote in message
...
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

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"CLR" wrote in message
...
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



"louannes" wrote in message
...
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