| 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". |
| 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 | |||
Threaded Mode
