如何在EXCEL将300014.SZ变成SZ300014

1 个回答

体检看 2024-07-20

提问：如何在EXCEL将300014.SZ变成SZ300014

网友回答：

输入公式：=TRIM(RIGHT(SUBSTITUTE(A2,".",REPT(" ",100)),100))&TRIM(LEFT(SUBSTITUTE(A2,".",REPT(" ",100)),100))