ExcelBanter - How do I sort a column of IP addresses ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I sort a column of IP addresses ? (https://www.excelbanter.com/excel-worksheet-functions/63428-how-do-i-sort-column-ip-addresses.html)

Chris

How do I sort a column of IP addresses ?

I have a spreadsheet with a column of IP addresses to sort.

I want, for example, the text strings 192.168.1.2 and 192.168.1.3 to be
numerically sorted ahead of 192.168.1.10

Can this be easily done ?
Thanks

Chris

How do I sort a column of IP addresses ?

Please ignore this question, it has been well covered - my first search
didn't find the right threads - sorry!

Chris

"Chris" wrote:

I have a spreadsheet with a column of IP addresses to sort.

I want, for example, the text strings 192.168.1.2 and 192.168.1.3 to be
numerically sorted ahead of 192.168.1.10

Can this be easily done ?
Thanks

All times are GMT +1. The time now is 04:23 AM.