有一列数字 比如前一个输入C1521B 我后一个想要得到1500X2150
提问：有一列数字 比如前一个输入C1521B 我后一个想要得到1500X2150
网友回答：
=MID(D1,2,2)&CHOOSE(CODE(RIGHT(D1,1))-64,"5","0","5")&"0X"&MID(D1,4,2)&CHOOSE(CODE(RIGHT(D1,1))-64,"0","5","5")&"0"
提问：有一列数字 比如前一个输入C1521B 我后一个想要得到1500X2150
网友回答：
=MID(D1,2,2)&CHOOSE(CODE(RIGHT(D1,1))-64,"5","0","5")&"0X"&MID(D1,4,2)&CHOOSE(CODE(RIGHT(D1,1))-64,"0","5","5")&"0"
盒子游戏,游戏玩家专属个性阅读社区