=MID(A1,2,LEN(A1)-1) =REPLACE(A6,1,5,"")
=MID(A1,2,LEN(A1)-1)
=REPLACE(A6,1,5,"")
上述的A6代表单元格,
1代表从第几个字符开始,
5代表共删除几个字符。
参考:https://zhidao.baidu.com/question/139361163551791205
1:
2: