Sorting List of IP Addresses
Posted by Kelly Steensma on August 24, 2001 9:55 AM
Anyone have a great idea of how to sort a list of IP addresses? Excel sorts my list like this:
I need it sorted like this:
One good way to make this work would be to break each ip address into four distinct columns and then sort A,B,C & then D, but I can't think of any formuals that would divide the cell based on when a decimal is encountered.