MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Posted by Mark W. on August 24, 2001 9:58 AM

Kelly, you don't need a formula... just use the
Data | Text to Columns... menu command to parse
a Delimited file specifying the delimiter as ".".