提取相同特殊符号中间字段。。需要智商支援。。。。请教高手。。。 ...

走了你还有谁

主题：提取相同特殊符号中间字段。。需要智商支援。。。。请教高手。。。
不用分列，后续需要组合公式方便生产。。需要函数提取。。。具体附图和excel

提取相同特殊符号中间字段.7z (5.89 KB, 下载次数: 14)

2021-12-7 21:50 上传

点击文件名下载附件
提取相同特殊符号中间字段.7z

汉梁

B2右拉下拉，一条公式
=TRIM(MID(SUBSTITUTE("*"&$A2,"*",REPT(" ",66)),COLUMN(A1)*66,66))

赵布

谢谢高手指导，工作方便多了。因为工作性质涉及公英制转公制，方便操作者。IF(ISNUMBER(FIND("/",G3)),"英寸→mm："&IF(ISNUMBER(FIND("mm",G3)),TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(A1)*66,66)),IF(ISNUMBER(FIND("/",G3)),25.4*(IF(ISNUMBER(FIND("/",TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(A1)*66,66))))*NOT(ISNUMBER(FIND("-",TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(A1)*66,66))))),"0 ","")&SUBSTITUTE(SUBSTITUTE(TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(A1)*66,66)),"""",),"-"," ")),""))&"x"&IF(ISNUMBER(FIND("mm",G3)),TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(B1)*66,66)),IF(ISNUMBER(FIND("/",G3)),25.4*(IF(ISNUMBER(FIND("/",TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(B1)*66,66))))*NOT(ISNUMBER(FIND("-",TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(B1)*66,66))))),"0 ","")&SUBSTITUTE(SUBSTITUTE(TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(B1)*66,66)),"""",),"-"," ")),""))&"x"&IF(ISNUMBER(FIND("mm",G3)),TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(C1)*66,66)),IF(ISNUMBER(FIND("/",G3)),25.4*(IF(ISNUMBER(FIND("/",TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(C1)*66,66))))*NOT(ISNUMBER(FIND("-",TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(C1)*66,66))))),"0 ","")&SUBSTITUTE(SUBSTITUTE(TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(C1)*66,66)),"""",),"-"," ")),""))&"x"&IF(ISNUMBER(FIND("mm",G3)),TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(D1)*66,66)),IF(ISNUMBER(FIND("/",G3)),25.4*(IF(ISNUMBER(FIND("/",TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(D1)*66,66))))*NOT(ISNUMBER(FIND("-",TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(D1)*66,66))))),"0 ","")&SUBSTITUTE(SUBSTITUTE(TRIM(MID(SUBSTITUTE("*"&$G3,"*",REPT(" ",66)),COLUMN(D1)*66,66)),"""",),"-"," ")),"")),"")

长春林

太感谢了。