林昊嵩 发表于 2021-12-21 15:10:00

根据A列截取得到B列

截取A列镇或者处后面的内容放到B列

嘴炮包青天 发表于 2022-1-1 05:05:22

=IFERROR(RIGHT(A1,LEN(A1)-(FIND("办事处",A1)+2)),RIGHT(A1,LEN(A1)-(FIND("镇",A1))))

夜来夜匪 发表于 2022-1-2 21:50:45

REPLACE(A1,1,MIN(FIND({"处","镇"},A1&"处镇")),)

低吟轻语 发表于 2022-1-23 22:06:22

=SUBSTITUTE(A1,LEFT(A1,MAX(IFERROR(FIND({"处","镇"},A1),""))),"")三键结束 下拉

耳總 发表于 2022-2-26 03:50:27

=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A1,"处","镇"),"镇",REPT(" ",99)),99))

人间正义 发表于 2022-3-7 03:12:58

=REPLACE(A1,1,MIN(FIND({"处","镇"},A1&"处镇")),)
=RIGHT(A1,LEN(A1)-MIN(FIND({"处","镇"},A1&"处镇")))

股海呀 发表于 2022-3-9 02:43:12

=MID(A1,MIN(FIND({"处","镇"},A1&"处镇"))+1,9)

枯叶螳螂 发表于 2022-3-12 12:55:59

=MID(A3,SUM(IFERROR(FIND({"处";"镇"},A3,1),0))+1,9)
页: [1]
查看完整版本: 根据A列截取得到B列