View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default

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