新加一列,把下面的公式复制进去,把D81变成IP列的值,然后下拉复制,再按刚换算好的列排序就OK了。
=TRIM(TEXT(LEFT(SUBSTITUTE(D81,".",REPT(" ",99)),100),"000")&TEXT(MID(SUBSTITUTE(D81,".",REPT(" ",99)),100,100),"000")&TEXT(MID(SUBSTITUTE(D81,".",REPT(" ",99)),200,100),"000")&TEXT(MID(SUBSTITUTE(D81,".",REPT(" ",99)),300,100),"000"))