EXCEL 提取单元格值中特殊符号的前后值？ Excel中截取指定特殊符号之前，之中、之后的数据怎么做？
Excel\u4e2d\u622a\u53d6\u6307\u5b9a\u7279\u6b8a\u7b26\u53f7\u4e4b\u524d\uff0c\u4e4b\u4e2d\u3001\u4e4b\u540e\u7684\u6570\u636e\u697c\u4e0a\u7684\u516c\u5f0f\u6709\u70b9\u592a\u957f\uff0c\u592a\u590d\u6742\u4e86\uff0c\u6211\u505a\u4e86\u4e00\u4e0b\u4fee\u6539\uff0c\u5df2\u6d4b\u8bd5\u8fc7\uff0c\u62ff\u53bb\u8bd5\u8bd5\u5427\uff01
1.\u516c\u5f0f =mid(a1,find("\u00d7",a1)+1,find("\u00d7",a1,find("\u00d7",a1)+1)-find("\u00d7",a1)-1)
2.\u516c\u5f0f =left(a1,find("\u00d7",a1)-1)
3.\u516c\u5f0f =right(a1,len(a1)-find("\u00d7",a1,find("\u00d7",a1)+1))
\u5728b1\u8f93\u5165\u516c\u5f0f2\uff0c\u5728C1\u8f93\u5165\u516c\u5f0f1\uff0c\u5728D1\u8f93\u5165\u516c\u5f0f3\uff0c\u9009\u4e2dB1:D1\u4e0b\u62c9\u586b\u5145\u5230B3:D3\uff0c\u53ef\u6309\u539f\u5355\u5143\u683c\u987a\u5e8f\u6392\u5217\u3002
\u6ce8\u610f\uff1a\u516c\u5f0f\u4e2d\u7684\u00d7\u590d\u5236\u81ea\u4f60\u63d0\u95ee\u4e2d\uff0c\u5982\u679cEXCEL\u8868\u91cc\u4e0d\u662f\u6b64\u5b57\u7b26\uff0c\u8bf7\u7528\u6b63\u786e\u7684\u5b57\u7b26\u66ff\u6362\u516c\u5f0f\u4e2d\u7684\u3002
\u53e6\uff1a\u5728\u516c\u5f0f\u7684"="\u540e\u9762\u589e\u52a0\u4e24\u4e2a\u51cf\u53f7"-"\uff0c\u53ef\u628a\u516c\u5f0f\u5f97\u5230\u7684\u5b57\u7b26\u8f6c\u6362\u6210\u6570\u5b57\u683c\u5f0f\u3002
\u697c\u4e0a\u7684\u516c\u5f0f\u6709\u70b9\u592a\u957f\uff0c\u592a\u590d\u6742\u4e86\uff0c\u6211\u505a\u4e86\u4e00\u4e0b\u4fee\u6539\uff0c\u5df2\u6d4b\u8bd5\u8fc7\uff0c\u62ff\u53bb\u8bd5\u8bd5\u5427\uff01
1.\u516c\u5f0f =mid(a1,find("\u00d7",a1)+1,find("\u00d7",a1,find("\u00d7",a1)+1)-find("\u00d7",a1)-1)
2.\u516c\u5f0f =left(a1,find("\u00d7",a1)-1)
3.\u516c\u5f0f =right(a1,len(a1)-find("\u00d7",a1,find("\u00d7",a1)+1))
\u5728b1\u8f93\u5165\u516c\u5f0f2\uff0c\u5728C1\u8f93\u5165\u516c\u5f0f1\uff0c\u5728D1\u8f93\u5165\u516c\u5f0f3\uff0c\u9009\u4e2dB1:D1\u4e0b\u62c9\u586b\u5145\u5230B3:D3\uff0c\u53ef\u6309\u539f\u5355\u5143\u683c\u987a\u5e8f\u6392\u5217\u3002
\u6ce8\u610f\uff1a\u516c\u5f0f\u4e2d\u7684\u00d7\u590d\u5236\u81ea\u4f60\u63d0\u95ee\u4e2d\uff0c\u5982\u679cEXCEL\u8868\u91cc\u4e0d\u662f\u6b64\u5b57\u7b26\uff0c\u8bf7\u7528\u6b63\u786e\u7684\u5b57\u7b26\u66ff\u6362\u516c\u5f0f\u4e2d\u7684\u3002
\u53e6\uff1a\u5728\u516c\u5f0f\u7684"="\u540e\u9762\u589e\u52a0\u4e24\u4e2a\u51cf\u53f7"-"\uff0c\u53ef\u628a\u516c\u5f0f\u5f97\u5230\u7684\u5b57\u7b26\u8f6c\u6362\u6210\u6570\u5b57\u683c\u5f0f\u3002
第一问，提取/前：=--LEFT(TEXT(A2,"??/??"),FIND("/",TEXT(A2,"??/??"))-1)
提取/后：=--MID(TEXT(A2,"??/??"),FIND("/",TEXT(A2,"??/??"))+1,2)
第二问的485(-2)的单元格格式是啥？
B2输入 =LEFT(A2,FIND("/",A2)-1)
C2输入 =MID(A2,FIND("/",A2)+1,9)
B5输入 =LEFT(A5,FIND("(",A5)-1)
C5输入 =LOOKUP(6^6,--MID(A5,FIND("(",A5)+1,ROW($1:$9)))
如图：
B1公式：
=--MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,")",""),"(",REPT(" ",10)),"/",REPT(" ",10)),(COLUMN(A1)-1)*10+1,10)
右拉到C1，再下拉。
=IF(MID(A1,2,1)="/",LEFT(A1,1),LEFT(A1,2)) ‘前值
=IF(MID(A1,2,1)="/",MID(A1,3,2),MID(A1,4,2)) ’后值
/前数字
=LOOKUP(99,--MID(A1,FIND("/",A1)-{1,2},{1,2}))
/后数字
=LOOKUP(99,--MID(A1,FIND("/",A1)+1,{1,2}))
扩展阅读：excel提取特定内容文字 ... excel表格提取想要的 ... exl 提取内容中间的一段 ... excel 引用另一表格值 ... excel 提取最大最小值 ... excel提取文字和数字 ... 表格批量提取部分内容 ... excel 获取单元格数值 ... excel 提取单元格中一部分数字 ...
