有组数字怎么用逗号把后三位割开110624001492110624002530110624003690110624004394110624005049110624006454110624007765110624008484110624009858必须是110624002,530110624003,690110624004,394110624005,049其他的都不行,有批
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/29 00:12:50
![有组数字怎么用逗号把后三位割开110624001492110624002530110624003690110624004394110624005049110624006454110624007765110624008484110624009858必须是110624002,530110624003,690110624004,394110624005,049其他的都不行,有批](/uploads/image/z/1558151-71-1.jpg?t=%E6%9C%89%E7%BB%84%E6%95%B0%E5%AD%97%E6%80%8E%E4%B9%88%E7%94%A8%E9%80%97%E5%8F%B7%E6%8A%8A%E5%90%8E%E4%B8%89%E4%BD%8D%E5%89%B2%E5%BC%80110624001492110624002530110624003690110624004394110624005049110624006454110624007765110624008484110624009858%E5%BF%85%E9%A1%BB%E6%98%AF110624002%EF%BC%8C530110624003%EF%BC%8C690110624004%EF%BC%8C394110624005%EF%BC%8C049%E5%85%B6%E4%BB%96%E7%9A%84%E9%83%BD%E4%B8%8D%E8%A1%8C%EF%BC%8C%E6%9C%89%E6%89%B9)
有组数字怎么用逗号把后三位割开110624001492110624002530110624003690110624004394110624005049110624006454110624007765110624008484110624009858必须是110624002,530110624003,690110624004,394110624005,049其他的都不行,有批
有组数字怎么用逗号把后三位割开
110624001492
110624002530
110624003690
110624004394
110624005049
110624006454
110624007765
110624008484
110624009858
必须是
110624002,530
110624003,690
110624004,394
110624005,049
其他的都不行,有批量改的那位高手告诉我非常感谢
有组数字怎么用逗号把后三位割开110624001492110624002530110624003690110624004394110624005049110624006454110624007765110624008484110624009858必须是110624002,530110624003,690110624004,394110624005,049其他的都不行,有批
放到Excel里面,用公式插入一个逗号就可以了.
=LEFT(A1,LEN(A1)-3) & "," & RIGHT(A1,3)
这样不对吗
110624001,492
110624002,530
110624003,690
110624004,394
110624005,049
110624006,454
110624007,765
110624008,484
110624009,858
110624001,492
2,530
3,690
4,394
5,049
6,454
7,765
8,484
...
全部展开
110624001,492
2,530
3,690
4,394
5,049
6,454
7,765
8,484
9,858
收起