note icon indicating copy to clipboard operation
note copied to clipboard

Published 20 hours ago • verified publisher icon aiastia

提取ip前三段

Open aiastia opened this issue 5 years ago • 0 comments

=LEFT(G1,FIND("*",SUBSTITUTE(G1,".","*",LEN(G1)-LEN(SUBSTITUTE(G1,".",""))))-1) LEN(G1)-LEN(SUBSTITUTE(G1,".",""))=3 SUBSTITUTE(G1,".","",LEN(G1)-LEN(SUBSTITUTE(G1,".","")))=192.168.11

aiastia avatar May 27 '19 10:05 aiastia