请问如何在excel中提取指定文字内容，谢谢！

发布网友发布时间：2022-03-07 00:04

共4个回答

热心网友时间：2022-03-07 01:33

稍等正在写函数.....

B2=MID($A2,FIND("购",$A2)+1,FIND("(",$A2)-FIND("购",$A2)-1)

C2=MID($A2,FIND("(",$A2)+1,FIND(")",$A2)-FIND("(",$A2)-1)

D2=MID(SUBSTITUTE($A2,"(","a",2),FIND(")",SUBSTITUTE($A2,"(","a",2))+1,FIND("a",SUBSTITUTE($A2,"(","a",2))-FIND(")",SUBSTITUTE($A2,")","a",2))-2)

E2=MID(SUBSTITUTE($A2,"(","a",2),FIND("a",SUBSTITUTE($A2,"(","a",2))-1,1)

F2=MID(SUBSTITUTE(SUBSTITUTE($A2,"(","a",2),")","b",2),FIND("a",SUBSTITUTE(SUBSTITUTE($A2,"(","a",2),")","b",2))+1,FIND("b",SUBSTITUTE(SUBSTITUTE($A2,"(","a",2),")","b",2))-FIND("a",SUBSTITUTE(SUBSTITUTE($A2,"(","a",2),")","b",2))-1)

G2=SUBSTITUTE(RIGHT(SUBSTITUTE(SUBSTITUTE($A2,"(",""),")","a",2),LEN(SUBSTITUTE(SUBSTITUTE($A2,"(",""),")","a",2))-FIND("a",SUBSTITUTE(SUBSTITUTE($A2,"(",""),")","a",2))),")","")

下拉

热心网友时间：2022-03-07 02:51

ctrl+h

查找内容(
替换为)
单击全部替换

然后
数据>分列>分隔符号>其它里输入) 完成

数量和单位要分开有点难处理

热心网友时间：2022-03-07 04:26

先对A的内容做替换，把”购”，”)(“，“(”，“)"都替换为”|“，然后用”|“做分隔符分列即可。
用函数太麻烦了...

热心网友时间：2022-03-07 06:17

1、针对B2单元格公式定义名称：CTRL+F3，名称中输入RWS，引用位置输入公式=IF(ISNUMBER(MATCH(MID($A1,ROW(INDIRECT("$1:$"&LEN($A1))),1),{"购";"(";")"},0)),ROW(INDIRECT("$1:$"&LEN($A1))),"")
2、B2
=MID($A1,SMALL(rws,COLUMN(A1)-N(COLUMN(A1)=5))+1-2*(COLUMN(A1)=4),IF(COLUMN(A1)=4,1,SMALL(rws,COLUMN(B1)-N(COLUMN(A1)=5))-SMALL(rws,COLUMN(A1)-N(COLUMN(A1)=5))-N(COLUMN(A1)=3)-1)) 右拉填充，下拉填充