如何在EXCEL将300014.SZ变成SZ300014
提问：如何在EXCEL将300014.SZ变成SZ300014
网友回答：
输入公式：=TRIM(RIGHT(SUBSTITUTE(A2,".",REPT(" ",100)),100))&TRIM(LEFT(SUBSTITUTE(A2,".",REPT(" ",100)),100))
提问：如何在EXCEL将300014.SZ变成SZ300014
网友回答：
输入公式：=TRIM(RIGHT(SUBSTITUTE(A2,".",REPT(" ",100)),100))&TRIM(LEFT(SUBSTITUTE(A2,".",REPT(" ",100)),100))
盒子游戏,游戏玩家专属个性阅读社区