Hi,欢迎访问生活学习的点滴博客
=LEFT(C1,FIND("192.",C1)-1)
=RIGHT(D1,LEN(D1)-FIND("192.",D1))
=SUBSTITUTE(B1,A1,"",1)
0条评论