| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sort a column of IP addresses ?
Please ignore this question, it has been well covered - my first search
didn't find the right threads - sorry! Chris "Chris" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort Excel Column on Fifth Character | Excel Worksheet Functions | |||
| How can I sort one column and have the entire row sort. (binding) | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
