辅助列IP地址排序
2024-12-09 本文已影响0人
自然一夏
辅助列IP地址排序
=TRIM(TEXT(LEFT(SUBSTITUTE(A3,".",REPT(" ",99)),100),"000")&TEXT(MID(SUBSTITUTE(A3,".",REPT(" ",99)),100,100),"000")&TEXT(MID(SUBSTITUTE(A3,".",REPT(" ",99)),200,100),"000")&TEXT(MID(SUBSTITUTE(A3,".",REPT(" ",99)),300,100),"000"))
