有组数字怎么用逗号把后三位割开110624001492110624002530110624003690110624004394110624005049110624006454110624007765110624008484110624009858必须是110624002,530110624003,690110624004,394110624005,049其他的都不行,有批
来源:学生作业帮助网 编辑:六六作业网 时间:2024/11/24 17:56:31
有组数字怎么用逗号把后三位割开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
收起