Sort by IP

From: "George Wilson" <GeorgeWilson@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 14 Jun 2005 08:31:02 -0700

I have a spread*** 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
.

Follow-Ups:
- RE: Sort by IP
  - From: George Wilson
- Re: Sort by IP
  - From: Jim Cone
- Re: Sort by IP
  - From: David McRitchie
- Re: Sort by IP
  - From: Bob Phillips
- Re: Sort by IP
  - From: Ron Rosenfeld

Prev by Date: RE: Same format using =
Next by Date: Re: Relative reference autofill increment other than +1
Previous by thread: Pulling product pricing from work*** into proposal template
Next by thread: Re: Sort by IP
Index(es):
- Date
- Thread