RE: Sort by IP

I needed to turn this around quickly yesterday so I used the "text to column"
separated by "." Since I will be maintaining IP addresses in the future I
will look into the macro sort options. Thank you all for your assistance.
George

"George Wilson" wrote:

> 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
.