On Tue, 14 Jun 2005 08:31:02 -0700, "George Wilson"
wrote:

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

Yes, you can use the Data/Text to Columns wizard and divide the data by '.'.
Then sort on each column -- see HELP for "Sort by 4 columns" after selecting
"Sort a List".

You could also sort using a macro.


--ron