发布网友 发布时间:4小时前
共3个回答
热心网友 时间:3分钟前
假如A1中为20.5m*30.5m,可以在B1中输入:热心网友 时间:2分钟前
=IF(ISERROR(MID(SUBSTITUTE(A1,"m",""),1,SEARCH("~*",SUBSTITUTE(A1,"m",""),1)-1)*MID(SUBSTITUTE(A1,"m",""),SEARCH("~*",SUBSTITUTE(A1,"m",""),1)+1,LEN(SUBSTITUTE(A1,"m",""))-1)),"",MID(SUBSTITUTE(A1,"m",""),1,SEARCH("~*",SUBSTITUTE(A1,"m",""),1)-1)*MID(SUBSTITUTE(A1,"m",""),SEARCH("~*",SUBSTITUTE(A1,"m",""),1)+1,LEN(SUBSTITUTE(A1,"m",""))-1))热心网友 时间:3分钟前
20.5m*30.5m 在A1单元格