EXCEL用公式来进行单位换算

=ROUND(LEFT(A1,LEN(A1)-4)*VLOOKUP(RIGHT(LEFT(A1,LEN(A1)-3)),{K,1;M,1024;G,1048576},2,)/1024,1)&Mbps