*GB-BPYJVP3*150+3*25 *GB-CEFR3*4 GB-FDZ-KEXF10*1 *GB-PNCT7*4+4*1 *GBDC-RVV3*10+2*2.5 *GB-WTGGE3*95+2*50 *GB-FDZ-YEYHP-0.6/2KV-1*70 *GB-JEFR-10KV-1*70 *GB-JEPJ-10KV-1*70 *GB-SS-FDZ-YEYH-0.6/1KV-1*70 *GB-SS-FDZ-YYH-G-0.6/1KV-1*70 *GB-WDZ-JEPJ-125-10KV-
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/13 12:18:53
![*GB-BPYJVP3*150+3*25 *GB-CEFR3*4 GB-FDZ-KEXF10*1 *GB-PNCT7*4+4*1 *GBDC-RVV3*10+2*2.5 *GB-WTGGE3*95+2*50 *GB-FDZ-YEYHP-0.6/2KV-1*70 *GB-JEFR-10KV-1*70 *GB-JEPJ-10KV-1*70 *GB-SS-FDZ-YEYH-0.6/1KV-1*70 *GB-SS-FDZ-YYH-G-0.6/1KV-1*70 *GB-WDZ-JEPJ-125-10KV-](/uploads/image/z/2602548-36-8.jpg?t=%2AGB-BPYJVP3%2A150%2B3%2A25+%2AGB-CEFR3%2A4+GB-FDZ-KEXF10%2A1+%2AGB-PNCT7%2A4%2B4%2A1+%2AGBDC-RVV3%2A10%2B2%2A2.5+%2AGB-WTGGE3%2A95%2B2%2A50+%2AGB-FDZ-YEYHP-0.6%2F2KV-1%2A70+%2AGB-JEFR-10KV-1%2A70+%2AGB-JEPJ-10KV-1%2A70+%2AGB-SS-FDZ-YEYH-0.6%2F1KV-1%2A70+%2AGB-SS-FDZ-YYH-G-0.6%2F1KV-1%2A70+%2AGB-WDZ-JEPJ-125-10KV-)
*GB-BPYJVP3*150+3*25 *GB-CEFR3*4 GB-FDZ-KEXF10*1 *GB-PNCT7*4+4*1 *GBDC-RVV3*10+2*2.5 *GB-WTGGE3*95+2*50 *GB-FDZ-YEYHP-0.6/2KV-1*70 *GB-JEFR-10KV-1*70 *GB-JEPJ-10KV-1*70 *GB-SS-FDZ-YEYH-0.6/1KV-1*70 *GB-SS-FDZ-YYH-G-0.6/1KV-1*70 *GB-WDZ-JEPJ-125-10KV-
*GB-BPYJVP3*150+3*25
*GB-CEFR3*4
GB-FDZ-KEXF10*1
*GB-PNCT7*4+4*1
*GBDC-RVV3*10+2*2.5
*GB-WTGGE3*95+2*50
*GB-FDZ-YEYHP-0.6/2KV-1*70
*GB-JEFR-10KV-1*70
*GB-JEPJ-10KV-1*70
*GB-SS-FDZ-YEYH-0.6/1KV-1*70
*GB-SS-FDZ-YYH-G-0.6/1KV-1*70
*GB-WDZ-JEPJ-125-10KV-1*70
在EXCEL中怎么提取符号和英文字母后面的数字.例如*GB-WTGGE3*95+2*50 ,提取3*95+2*50;*GB-SS-FDZ-YEYH-0.6/1KV-1*70 提取1*70.最好就是同一公式能把两种同时提取.
*GB-BPYJVP3*150+3*25 *GB-CEFR3*4 GB-FDZ-KEXF10*1 *GB-PNCT7*4+4*1 *GBDC-RVV3*10+2*2.5 *GB-WTGGE3*95+2*50 *GB-FDZ-YEYHP-0.6/2KV-1*70 *GB-JEFR-10KV-1*70 *GB-JEPJ-10KV-1*70 *GB-SS-FDZ-YEYH-0.6/1KV-1*70 *GB-SS-FDZ-YYH-G-0.6/1KV-1*70 *GB-WDZ-JEPJ-125-10KV-
亲,如下图,B1的公式是数组公式.在单元格中粘贴完成以后,不要直接按回车退出,一定要按“Ctrl+Shift+回车”退出.然后下拉公式.
=RIGHT(A1,MIN(IF((CODE(LEFT(RIGHT(A1,ROW($1:$100)),1))>=65)*(CODE(LEFT(RIGHT(A1,ROW($1:$100)),1))<=90)+(CODE(LEFT(RIGHT(A1,ROW($1:$100)),1))=45),ROW($1:$100)))-1)