Sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a problem sorting in Excel. When I try to sort my list in Excel it
sorts like this:

1.1.1
1.1.11
1.1.2
11.1.1
2.1.1

I would like it to sort like this:
1.1.1
1.1.2
1.1.11
2.1.1
11.1.1

Is that possible?
 
See this post from 1998 on sorting IP addresses...
http://tinyurl.com/y6696s
Especially the one from Dana at the bottom of the page.
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html



"Kim" <[email protected]>
wrote in message
I have a problem sorting in Excel. When I try to sort my list in Excel it
sorts like this:

1.1.1
1.1.11
1.1.2
11.1.1
2.1.1

I would like it to sort like this:
1.1.1
1.1.2
1.1.11
2.1.1
11.1.1

Is that possible?
 
I don't think you really want to use Text to Columns,
and then sort on three columns. The following will
work even though most IP addresses have four nodes,
the sort will aligned on left though for normalized numbers.
I think if you had a mix of 3 nodes and 4 nodes you would
not get what you want.

see Sorting TCP/IP Addresses, and the like
http://www.mvps.org/dmcritchie/excel/sorttcp.htm
 
Back
Top