search

aiastia / note

笔记
17 stars 5 forks source link

提取ip前三段 #40

Open aiastia opened 5 years ago

aiastia commented 5 years ago

=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