Sort IP addresses

[KirstenNJ]

Is there a way to sort from smallest to largest, a list of IP addresses that have varying lengths?

They all start with the first same 7 characters but then they are different.

Example:
130.33.10.761
130.33.123.23
130.33.07.12

So I need them to sort the number between the 2nd and 3rd dot as well as the number after the 3rd dot.
Thanks,
-Kirsten

 

[bryonwoods30]

you could just do text to columns and choose the "." as the delimiter, then sort them how you wanted.

 

[KirstenNJ]

Perfect! Thank you!

 

[aroberge]

There's a good Excel spreadsheet tool that has a function to convert IP addresses to decimal numbers. Once that's done sorting is very easy.