MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sort by IP Addresses


Posted by gunner on September 20, 2001 12:37 PM

I'm having a hard time figuring out how to sort by ip addresses. example:

172.33.1.6
172.33.108.100
172.33.108.141
172.33.189.99
172.33.2.121
172.33.3.77
172.33.49.106


Posted by Eric on September 20, 2001 2:23 PM

saw a post on this earlier, use text to columns

Put your ip's in column a, highlight them, go Data-->text to columns, choose delimited, click custom, and use the period,
pulls your numbers out into separate columns and treats them as normal numbers.
HTH