[TOC]
IP排序：将A1单元格的IP地址补零为三位，再按自然数进行IP升序/降序排序
=TEXTJOIN(".",,TEXT(TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",100)),{1,101,201,301},100)),"000"))
[TOC]
=TEXTJOIN(".",,TEXT(TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",100)),{1,101,201,301},100)),"000"))
