Is there a way I can get Excel to sort w, x, y and z as 3 digit numbers? I
would like the result of the sort to be:-
Source:211.19.215.70, 1051, WAN -
Source:211.19.215.70, 1677, WAN -
Source:211.177.154.134, 1030, WAN -
Source:211.190.195.138, 2876, WAN -
Personally, I'd break up the IP addresses into 4 separate cells in a row
and do sorts on those to get to where you want to be. Someone else here
may have a better solution.
For example, you find the "w" part of the address w.x.y.z in cell A1 by
creating helper columns for values dot1, dot2 and dot3 then find w,x,y
and z:
dot1 = find(".",A1)
dot2 = find(".",A1,dot1+1)
dot3 = find(".",A1,dot2+1)
w = left(A1,dot1-1)
x = mid(A1,dot1+1,dot2-dot1-1)
y = mid(A1,dot2+1,dot3-dot2-1)
z = right(A1,len(A1)-dot3)
Good luck...
Bill
|