View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris
 
Posts: n/a
Default 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