左边数据 =LEFT(G1,FIND(" “,G1)-1) 右边数据 =RIGHT(G1,LEN(G1)-FIND(” ",G1)) 变换单位 =IF(J1=“MBs”,I110241024,IF(J1=“kBs”,I11024,IF(J1=“Bs”,I11)))
合并语句 =LEFT(B1,FIND(" “,B1)-1) =RIGHT(B1,LEN(B1)-FIND(” ",B1))
=IF(RIGHT(B1,LEN(B1)-FIND(" “,B1))=“GBs”,LEFT(B1,FIND(” “,B1)-1)10241024*1024,IF(RIGHT(B1,LEN(B1)-FIND(” “,B1))=“MBs”,LEFT(B1,FIND(” “,B1)-1)10241024,IF(RIGHT(B1,LEN(B1)-FIND(” “,B1))=“kBs”,LEFT(B1,FIND(” “,B1)-1)*1024,IF(RIGHT(B1,LEN(B1)-FIND(” “,B1))=“Bs”,LEFT(B1,FIND(” ",B1)-1)*1))))
效果图
