提取中间那部分（不包括括号）

AA5242 · 发表于 2023-12-20 13:56

各位老师，提取中间那部分（不包括括号），请指教一下，多谢啦！

博爱风雨同舟 · 发表于 2023-12-20 14:10

=TEXTBEFORE(TEXTAFTER(A1,"-"),{"(","（","."})

hugeinfo · 发表于 2023-12-20 14:11

本帖最后由 hugeinfo 于 2023-12-20 14:12 编辑

=SUBSTITUTE(TRIM(IFERROR(RIGHT(SUBSTITUTE(MID(A1,1,MAX(IFERROR(FIND({"(","（"},A1),0))-1),"-",REPT(" ",99),1),99),RIGHT(SUBSTITUTE(A1,"-",REPT(" ",99),1),99))),".SLDDRW","")

wengjh8848 · 发表于 2023-12-20 14:11

quqiyuan · 发表于 2023-12-20 14:14

=MID(A1,FIND("-",A1)+1,MIN(IFERROR(FIND({"(",".","（"},A1),99)-FIND("-",A1)-1))

AA5242 · 发表于 2023-12-20 14:14

博爱风雨同舟发表于 2023-12-20 14:10
=TEXTBEFORE(TEXTAFTER(A1,"-"),{"(","（","."})

老师，显示错误

AA5242 · 发表于 2023-12-20 14:18

quqiyuan 发表于 2023-12-20 14:14
=MID(A1,FIND("-",A1)+1,MIN(IFERROR(FIND({"(",".","（"},A1),99)-FIND("-",A1)-1))

太牛了，多谢老师

gadxjyang · 发表于 2023-12-20 14:19

A1括号需要调整和下面的相同
=RIGHT(LEFT(A2,MIN(IFERROR(FIND({"（","."},A2),99)-1)),LEN(LEFT(A2,MIN(IFERROR(FIND({"（","."},A2),99)-1)))-FIND("-",A2))

我走我流 · 发表于 2023-12-20 14:36

=VLOOKUP("*(",LEFT(ASC(SUBSTITUTE(REPLACE(A1,1,FIND("-",A1),),".","(.")),ROW($1:$99)-{0,1}),2,)

橒♂蝣 · 发表于 2023-12-20 16:11

=IFERROR(IFERROR(MID(A1,FIND("-",A1)+1,FIND("(",A1)-FIND("-",A1)-1),MID(A1,FIND("-",A1)+1,FIND("（",A1)-FIND("-",A1)-1)),MID(A1,FIND("-",A1)+1,99))

		自动登录	找回密码
密码			免费注册

[已解决] 提取中间那部分（不包括括号）

评分