怎么把excel里的数据按最后一个“,”分成两列?答:如果每个单元格中逗号的数量不相同,那么公式相对复杂些。假设数据在A列,以A1开始,结果放在B列,那么B1= MID(A1,FIND("@",SUBSTITUTE(A1,",","@",LEN(A1)-LEN(SUBSTITUTE(A1,",",)))+1,LEN(A1))说明:公式中“@”可以视情况替换为所有单元格中都未出现的一个其它字符。如果逗号的数量都...
EXCEL已经超出了SUBSTITUTE嵌套,怎么解决答:一个变通方法,如图 C,D两列分别写入对应内容 B2单元格写入公式 =F2&G2&H2&I2&J2&K2&L2&M2&N2 下拉填充 F2单元格写入公式 =IFERROR(VLOOKUP(MID($A2,COLUMN(A1),1),$C:$D,2,)&"",MID($A2,COLUMN(A1),1))右拉填充,再下拉填充公式 ...
用excel计算英制答:假设A1输入的是:(1'1 1/2")A2输入:(2'3 3/4")我们插入一个辅助列B,在B1输入:=LEFT(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),FIND("'",SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""))-1)*12+--MID(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),FIND("'",SUBSTITUTE(...
请帮忙解答这个EXCEL函数,一定要清楚到我可以掌握,谢谢指教答:a = Application.WorksheetFunction.Substitute(x.Value, 0, "")b = Application.WorksheetFunction.Substitute(a, 1, "")C = Application.WorksheetFunction.Substitute(b, 2, "")D = Application.WorksheetFunction.Substitute(C, 3, "")E = Application.WorksheetFunction.Substitute(D, 4, "")F = ...