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,":",""))))))
打赏

本文固定链接: https://www.cxy163.net/archives/2477 | 绝缘体

该日志由 绝缘体.. 于 2023年07月28日 发表在 首页 分类下,
原创文章转载请注明: excel截取ip+端口的当中的ip | 绝缘体

报歉!评论已关闭.