7 years ago
#3 Quote
To sort a list of IP addresses in Excel simply use the Sort IP Addresses button available on the IP Tools for Excel Ribbon. No script code or formulas needed.

Select the data to be sorted, maybe an entire worksheet all Columns.  Click Sort IP Addresses.  The Sort dialog box appears.  It is similar to the one in Excel.  

If Column A contains the list of IP addresses to be sorted check the box to indicate that it contains the IP addresses, and then choose Column A.  You may sort the IP addresses ascending or descending. An ascending sort will place the smallest IP address at the top of the list.

Add more levels and sort by Columns if you need to.