请问如何在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)) 右拉填充，下拉填充
