Assuming the 3rd group of numbers always start at character # 8th use the
following in a helper column
=MID(A1,8,SEARCH(".",A1,8)-8)
Then sort it based on the helper column
Nitin
"jf" wrote in message
...
For example I have:
172.21.34.82
172.21.48.80
172.21.48.83
172.22.42.100
172.22.42.101
172.24.10.15
172.24.10.16
172.24.102.12
172.24.14.15
And I want to sort this list by the third group of numbers.
"JF" wrote:
Trying to sort a list of IP addresses by the 3rd octet? Any
Suggestions?
Thanks,
Jim
|