|
请问如何把英寸转换成单位为厘米?
英寸 转厘米模拟结果如下:
13-1/2X19 34.29X48.26
10-1/4X20-3/8 26.04X51.75
10X1 25.4X2.54
10X0-1/2 25.4X1.27
以下公式只能转"X"前面的,"X"后面的转不了,求完善:
=VALUE(LEFT(SUBSTITUTE(A19,"-"," "),FIND("X",SUBSTITUTE(A19,"-"," "),1)-1))*2.54
本帖最后由 baksy 于 2021-6-17 15:43 编辑
C5复制公式,下拉;
=SUBSTITUTE(LEFT(A5,FIND("X",A5)-1),"-"," ")*2.54&"X"&SUBSTITUTE(MID(A5,FIND("X",A5)+1,9),"-"," ")*2.54
|
|