根据A列截取得到B列

林昊嵩

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

例子.zip (5.97 KB, 下载次数: 163)

2021-12-21 15:10 上传

点击文件名下载附件
例子.zip

嘴炮包青天

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

夜来夜匪

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

低吟轻语

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

耳總

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

人间正义

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

股海呀

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

枯叶螳螂

=MID(A3,SUM(IFERROR(FIND({"处";"镇"},A3,1),0))+1,9)