提问：有一列数字 比如前一个输入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"