1. 瀵繪壘EXCEL楂樻墜銆 鎴戞湁涓緇勬暟瀛楋細0350x0830鍦ㄤ竴涓鍗曞厓鏍煎唴錛屼腑闂寸殑絎﹀彿鏄疿,鎴戞兂鎶婁袱杈圭殑鏁板瓧鎻愬彇鍑烘潵銆
1銆佹瘮濡傛垜鍦˙5杈撳叆0350x0830錛屽傛灉X閮芥槸灝忓啓鐨勶紝鍙闇鍦ㄥ悗闈涓鍒楃殑琛ㄦ牸涓杈撳叆鍏寮==LEFT(B5,FIND("x",B5)-1)&MID(B5,FIND("x",B5)+1,9999)