Sorting IP Addresses

[cision_eq]

I am trying to sort a spreadsheet based on ip addresses. I cant seem to figure out how here is an example
machine ip address
test1 111.222.222.123
test2 111.222.222.132
test3 111.222.222.111
basically I want to sort on the last 3 digits
any info would be appreciated. thanks

[ This Message was edited by: cision_eq on 2002-04-10 06:24 ]

[Mark W.]

See http://www.mrexcel.com/board/viewtop...c=2365&forum=2.

[Aladin Akyurek]

On 2002-04-10 06:24, cision_eq wrote:
I am trying to sort a spreadsheet based on ip addresses. I cant seem to figure out how here is an example
machine ip address
test1 111.222.222.123
test2 111.222.222.132
test3 111.222.222.111
basically I want to sort on the last 3 digits
any info would be appreciated. thanks

[ This Message was edited by: cision_eq on 2002-04-10 06:24 ]

Lets say that the sample is in A1:B3.

In C1 enter and copy down:

Change the formula to:

=RIGHT(B1,LEN(B1)-LEN(SUBSTITUTE(B1,".","")))+0

Then sort on column C.

Aladin




[ This Message was edited by: Aladin Akyurek on 2002-04-10 06:51 ]

[Mark W.]

=RIGHT(B1,LEN(B1)-LEN(SUBSTITUTE(B1[ This Message was edited by: Aladin Akyurek on 2002-04-10 06:51 ]

Aladin, this formula won't work for...

111.222.222.12