A question came up on my Twitter feed this week – how to sort a list of IP Addresses in Excel. On the face of it, this should be simple. However, because Excel treats the IP addresses as text strings, not numbers, the sort order will not be correct, for example will come before (2 comes before 8 in an alphabetic sort).

You can find the complete step-by-step tutorial at theexceltrainer.co.uk