Jul
28
2023
excel截取ip+端口的当中的ip
#ip:端口 excel 取ip #2409:805b:5a06:2508::111:101:8781 =MID(A1,1,(FIND("@",SUBSTITUTE(A1,":","@",LEN(A1)-LEN(SUBSTITUTE(A1,":",""))))-1)) #取端口 =MID(A2,(FIND("@",SUBSTITUTE(A2,":","@",LEN(A2)-LEN(SUBSTITUTE(A2,":",""))))+1),(LEN(A2)-FIND("@",SUBSTITUTE(A2,":","@",LEN(A2)-LEN(SUBSTITUTE(A2,":",""))))))
最活跃的读者