I’m trying to sort a column of ip addresses in ascending order using Excel 97. The problem is that excel recognizes, for example, 10.252.16.120 as being lower in value than 10.252.16.22 and therefore the 16.120 address would be listed before the 16.22 address when doing an ascending sort since excel is interperating the “.” as a decimal. I would want the 16.22 to be listed before the 16.120 when I do an ascending sort. Is there a way to program excel to sort the column based on the last octet of the ip address if the first three octets in the column are the same? What if the first three octets vary?
