如何从excel中提取想要的字段

2024-12-02 10:24:33
推荐回答(5个)
回答1:

假设“广东省深圳市福田区华强北路2001号深纺大厦”在A1单元格
=MID(TRIM(A1),FIND("市",TRIM(A1))+1,FIND("区",TRIM(A1))-FIND("市",TRIM(A1)))

回答2:

这可以实现:加入以上是A1,你在B1单元格输入:
=MID(A1,FIND("福田区",A1),3)

回答3:

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"市",REPT(" ",99)),"区",REPT(" ",99)),99,99))&"区"

回答4:

=MID(TRIM(A1),FIND("市",TRIM(A1))+1,FIND("区",TRIM(A1))-FIND("市",TRIM(A1)))

回答5:

=MID(A1,FIND("福",A1),3)