Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sort by section number
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, ... |
#2
|
|||
|
|||
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, ... . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you change sort defaults for combined text number & hyphen. | Excel Discussion (Misc queries) | |||
How do I sort a column a unique number? | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |