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:

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.