内容提取为，用函数公式表达

鸭梨11

不用宏处理，单独用公式能否按以上要求提取出文字内容信息

cjyjimmy

鸭梨11 发表于 2023-4-13 10:54
非常感谢，

第10行的单元尺寸值有4个，能否只显示前面2个如8.6   5.01 后面的只不体现了，麻烦再帮我 ...

重新给你换了个公式

cjyjimmy

如果格式固定，可以这样

鸭梨11

cjyjimmy 发表于 2023-4-13 09:49
如果格式固定，可以这样

非常感谢，

第10行的单元尺寸值有4个，能否只显示前面2个如8.6   5.01 后面的只不体现了，麻烦再帮我改下

无聊的黑猫

是这意识吧

鸭梨11

无聊的黑猫 发表于 2023-4-13 10:58
是这意识吧

其他不用修改，只需要这这个为准只体现一个值后面的不要

无聊的黑猫

=IF(COLUMN(A1)=3,IFERROR(INDEX($E$1:$E$6,MOD(ROW(A1),6)),$E$6),INDEX(SUBSTITUTE(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(INDEX(TRIM(MID(SUBSTITUTE(SUBSTITUTE(INDEX($A$7:$A$12,ROUNDUP(ROW(A1)/6,0)),"  "," ")," ",REPT(" ",99)),ROW($1:$10)*99-98,99)),TRIM(MID(SUBSTITUTE(REPT(IF(LEN(INDEX($A$7:$A$12,ROUNDUP(ROW(A1)/6,0)))-LEN(SUBSTITUTE(INDEX($A$7:$A$12,ROUNDUP(ROW(A1)/6,0)),"*",""))>4," 1 10 3 7 6 6"," 1 9 3 7 6 6"),COUNTA($A$7:$A$12))," ",REPT(" ",99)),ROW(A1)*99,99))*1),"H=",""),"MM",""),"*",REPT(" ",99)),ROW($1:$4)*99-98,99)),"PCS",""),TRIM(MID(SUBSTITUTE(REPT(" 1 1 1 1 1 3",COUNTA($A$7:$A$12))," ",REPT(" ",99)),ROW(A1)*99,99))*1+COLUMN(A1)-1)) 下拉 右拉

橒♂蝣

=MID(A1,1,FIND(" ",A1)-1)

无聊的黑猫

=IF(COLUMN(A1)=3,IFERROR(INDEX($E$1:$E$6,MOD(ROW(A1),6)),$E$6),IF(MOD(ROW(),6)=4,INDEX(SUBSTITUTE(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(INDEX(TRIM(MID(SUBSTITUTE(SUBSTITUTE(INDEX($A$7:$A$12,ROUNDUP(ROW(A1)/6,0)),"  "," ")," ",REPT(" ",99)),ROW($1:$10)*99-98,99)),TRIM(MID(SUBSTITUTE(REPT(IF(LEN(INDEX($A$7:$A$12,ROUNDUP(ROW(A1)/6,0)))-LEN(SUBSTITUTE(INDEX($A$7:$A$12,ROUNDUP(ROW(A1)/6,0)),"*",""))>4," 1 10 3 7 6 6"," 1 9 3 7 6 6"),COUNTA($A$7:$A$12))," ",REPT(" ",99)),ROW(A1)*99,99))*1),"H=",""),"MM",""),"*",REPT(" ",99),1),ROW($1:$4)*99-98,99)),"PCS",""),TRIM(MID(SUBSTITUTE(REPT(" 1 1 1 1 1 3",COUNTA($A$7:$A$12))," ",REPT(" ",99)),ROW(A1)*99,99))*1+COLUMN(A1)-1),INDEX(SUBSTITUTE(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(INDEX(TRIM(MID(SUBSTITUTE(SUBSTITUTE(INDEX($A$7:$A$12,ROUNDUP(ROW(A1)/6,0)),"  "," ")," ",REPT(" ",99)),ROW($1:$10)*99-98,99)),TRIM(MID(SUBSTITUTE(REPT(IF(LEN(INDEX($A$7:$A$12,ROUNDUP(ROW(A1)/6,0)))-LEN(SUBSTITUTE(INDEX($A$7:$A$12,ROUNDUP(ROW(A1)/6,0)),"*",""))>4," 1 10 3 7 6 6"," 1 9 3 7 6 6"),COUNTA($A$7:$A$12))," ",REPT(" ",99)),ROW(A1)*99,99))*1),"H=",""),"MM",""),"*",REPT(" ",99)),ROW($1:$4)*99-98,99)),"PCS",""),TRIM(MID(SUBSTITUTE(REPT(" 1 1 1 1 1 3",COUNTA($A$7:$A$12))," ",REPT(" ",99)),ROW(A1)*99,99))*1+COLUMN(A1)-1))) 下拉 右拉 不改了 在原公式加加减减 越来越长 等有时间 在看看其他方法

鸭梨11

cjyjimmy 发表于 2023-4-13 11:33
重新给你换了个公式

https://club.excelhome.net/thread-1690413-1-1.html
这个帖子能否帮我做下公式，万分感谢