IP address sorting in excel

[Shaun Haines]

I am looking to sort IP address's in excel not being the
best excel user is ther an easy way to do this? the
format fot those of you who might not be familar it is a
range of numbers from 192.168.3.1-192.168.3.254 . I would
lik for it to give me the address in a numericle order.
Any suggestions?

 

[JE McGimpsey]

You can find a bunch of suggestions by searching the archives (use "IP
Sort," without quotes, as a key):

http://groups.google.com/advanced_group_search?q=group:*excel*

David McRitchie has an excellent suggestion here:

http://www.mvps.org/dmcritchie/excel/sorttcp.htm

 

[Trevor Shuttleworth]

Shaun

one option:

http://www.mofunzone.com/downloadsoftware/5000000036593.shtml


Regards

Trevor