IP地址Excel排序

by ITMX

公式如下

=SUMPRODUCT(MID(SUBSTITUTE(A2,".",REPT(" ",20)),{1,21,41,61},20)*10^{9,6,3,0})