EXCEL 如何在单元格的固定位置添加符号如22/33/44变成22a/33b/44c
EXCEL 如何在单元格的固定位置添加符号如22/33/44变成22a/33b/44c
日期：2021-10-17 15:23:17 人气：1
使用下列公式之一
=REPLACE(REPLACE(A1,3,,"a"),7,,"b")&"c"
=REPLACE(REPLACE(A1,6,,"b"),3,,"a")&"c"
=SUBSTITUTE(SUBSTITUTE(A1,"/","a/",1),"/","
=REPLACE(REPLACE(A1,3,,"a"),7,,"b")&"c"
=REPLACE(REPLACE(A1,6,,"b"),3,,"a")&"c"
=SUBSTITUTE(SUBSTITUTE(A1,"/","a/",1),"/","