Hi George,
see
Sorting TCP/IP Addresses, and the like
http://www.mvps.org/dmcritchie/excel/sorttcp.htm
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"George Wilson" <GeorgeWilson@discussions.microsoft.com> wrote in message news:15C28008-9D7E-4BEA-B9FE-03E2D080900E@microsoft.com...
> 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