Excel 将ip换成3位数公式

text(left(A1,find(".",A1)-1),"000")&"."&text(right(left(A1,find("%",substitute(A1,".","%",2))-1),find("%",substitute(A1,".","%",2))-find("%",substitute(A1,".","%",1))-1),"000")&"."&text(RIGHT(LEFT(A1,FIND("%",SUBSTITUTE(A1,".","%",3))-1),FIND("%",SUBSTITUTE(A1,".","%",3))-FIND("%",SUBSTITUTE(A1,".","%",2))-1),"000")&"."&text(right(A1,len(A1)-find("%",substitute(A1,".","%",3))),"000")