| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sort by IP
I have a spreadsheet I would like to sort by IP address. I have a format
192.168.2.1 but excel recognizes the next address as 192.168.2.10 then 192.168.2.100. I do not have leading zeros so I have been unsuccessfull parsing the data using LEFT and RIGHT functions and sorting that way. Can I divide the data by "."? is that necessary to accomplish the proper sort? TIA George |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
| "-" ignored in sort | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Threaded Mode
