走了你还有谁 发表于 2021-12-7 21:50:00

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

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

汉梁 发表于 2022-1-2 08:49:29

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

赵布 发表于 2022-1-24 14:40:09

谢谢高手指导，工作方便多了。因为工作性质涉及公英制转公制，方便操作者。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)),"""",),"-"," ")),"")),"")

长春林 发表于 2022-2-18 02:22:33

太感谢了。
页: [1]
查看完整版本: 提取相同特殊符号中间字段。。需要智商支援。。。。请教高手。。。 ...