Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort IP address.
I need to sort IP addresses. I capture data from a program and put then in
Excel. I need to be able to insert leading zeros in the sections that have less than 3-digits. IP address "123.123.123.3". If sorted "123.123.123.254" comes before "123.123.123.3". |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort IP address.
This Topic has been discussed many times. See this listing and see what you
like: http://groups.google.co.uk/groups?as...el.*&lr=&hl=en -- Regards, Tom Ogilvy "Dogwoodz" wrote in message ... I need to sort IP addresses. I capture data from a program and put then in Excel. I need to be able to insert leading zeros in the sections that have less than 3-digits. IP address "123.123.123.3". If sorted "123.123.123.254" comes before "123.123.123.3". |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort IP address.
Here is a trick that doesn't require the leading zeros. You will need 5
empty columns to the right of the IP column. If IPs are in column A copy them to column B. Select the IP list in column B. From the menu select Data/Text to Columns. Tell the Import Wizard "Delimited" and for the separator Other type "." (decimal without the quotes). This will create 4 columns with 1 number each from the IP. Now select the entire block of data (columns A:E) and from the menu select Data/Sort and choose column E - Ascending. Now you can delete columns B:E, leaving column A sorted correctly. Mike F "Dogwoodz" wrote in message ... I need to sort IP addresses. I capture data from a program and put then in Excel. I need to be able to insert leading zeros in the sections that have less than 3-digits. IP address "123.123.123.3". If sorted "123.123.123.254" comes before "123.123.123.3". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable Excel to Sort by IP Address | Excel Worksheet Functions | |||
sort e-mail address | Excel Discussion (Misc queries) | |||
sort in excel using end of email address | Excel Worksheet Functions | |||
how do I sort email address by ISP? | Excel Worksheet Functions | |||
How Do I sort an IP address by the 3rd Octet? | Excel Worksheet Functions |