How do I sort a column of IP addresses ?

C

Chris

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
 
C

Chris

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

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Centered text that does not stay centered 0
Cannot sort a table containing text 5
Sorting Multiple Tables 1
Have 4 email addresses Want to auto forward all in one of them 0
How to center adjust text above and image in a two column document. 1
How to bulk add section breaks after a particular combination of letters/numbers 0
InfoPath 2010 form in WinForms app 0
Merging from an Excel file with graphics 1

Top