note
note copied to clipboard
提取ip前三段
=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