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

Assuming none of the numbers every exceed 99 and there is
always 3 parts to each section, try this in a open col.:

=TEXT(LEFT(A1,FIND(".",A1)-1),"00")&TEXT(MID(A1,FIND
(".",A1)+1,2),"00")&TEXT(SUBSTITUTE(RIGHT
(A1,2),".",""),"00")

and fill down. Now select both columns and sort on this
new column.

If your col. of data in not in A, change the formula
references.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to sort a list of bulleted numbered sections.

Excel sorts it like this: 2.7.1, 2.7.10,

2.7.12,...,2.7.2,...

How do I sort it like this: 2.7.1, 2.7.2, ..., 2.7.10,

2.7.12, ...
.