假设原单元格在A1 首先保证编码位数格式都一样
如果你是想要 6950100215 变 695001000215
B1输入公式 =left(a1,3)&"0"&mid(a1,4,2)&"0"&right(a1,len(a1)-5)
如果你是想要 695-01-00215 变 695-001-000215
B1输入公式 =left(a1,4)&"0"&mid(a1,5,3)&"0"&right(a1,len(a1)-7)
或者给我发过来,我看看,
[email protected] 我把结果给你贴出来吧
2310010002153
2310010002177
2310010002214
2310010002221
2310010002269
2310010002276
2320010000080
2320010000097
2320010000110
2320010000127
2320010000134
2320010000257
2320010000271
2320010000288
2320010000295
2320010000301
2320010000400
2320010000417
2320010000424
2320010000431
2320010000448
2320010000455
2320010000462
2320010000479
2320010000509
2320010000516
2320010000523
2320010000530
2320010000547
2320010000554
2320010000561
2320010000578
2320010000585
2320010000592
2320010001056
2320010001063
2320010001070
2320010001087
2320010001094
2320010001100
2320010001117
2320010001124
2320010001131
2320010001209
2320010001216
2320010001230
2320010001247
2320010001254
2320010001261
2320010001278
2320010001285
2330010000010
2330010000027
2330010000034
2330010000041
2330010000058
2330010000065
2330010000072
2330010000089
2330010000096
2330010000102
2330010000119
2330010000133
2330010000201
2330010000218
2330010000225
2330010000232
2330010000249
2330010000256
2330010000263
2330010000270
2330010000287
2330010000294
2330010000300
2330010000317
2330010000409
2330010000416
2330010000423
2330010000430
2330010000447
2330010000454
2330010000461
2330010000508
2330010000515
2330010000522
2330010000539
2330010000546
2330010000553
2330010000560
2330010000577
2330010000584
2330010000591
2330010000652
2330010000669
2330010000676
2330010000683
2330010000690
2330010000706
2330010000805
2330010000812
2330010000829
2330010000836
2330010000843
2330010000850
2330010000904
2330010000911
2330010000928
2330010000935
2330010000942
2330010001031
2330010001055
2330010002014
2330010002021
2330010002052
2330010002083
2330010002090
2330010002106
2330010002175
2330010002182
2330010002199
2330010002205
2330010002359
2330010002366
2330010002373
2330010002380
2330010002465
2330010002472
2330010002489
2330010002496
2330010002502
2330010002519
2330010002526
2330010002533
2330010003080
2330010003097
2330010003103
2330010003110
2330010003127
2330010003295
2330010003301
2330010003325
2330010003332
2330010003349
2330010003400
2330010003417
2330010003424
2330010004018
2330010004063
2330010004070
2330010004087
2330010004094
2330010004216
2330010004230
2330010004247
2330010004254
2330010004261
2330010004278
2330010004285
2330010004315
2330010004322
2330010004339
2330010004346
2330010004353
2330010004360
2330010004377
2330010004384
2330010004391
2330010004407
2330010004513
2330010004520
2330010004537
2330010004889
2330010004896
2330010004919
2330010004933
2330010005084
2330010005091
2330010005107
2330010005114
2330010005121
2350020000015
2350020000039
2350020000046
2350020000053
2350020000060
2350020000077
2350020000084
2350020000107
2350020000114
2350020000121
2350020000138
2350020000145
2350020000152
2350020000206
2350020000213
2350020000220
2350020000237
2350020000244
2350020000305
2350020000312
2350020000329
2350020000336
2350020000343
2350020000350
2350020000404
2350020000411
2350020000428
2350020000435
2350020000442
2350020000503
2350020000510
2350020000527
2350020000534
2350020000541
2350020000558
2350020000602
2350020000619
2350020000626
2350020000633
2350020000640
2350020000657
2350020000701
2350020000718
2350020000725
2350020000732
2350020000749
2350020000756
2350020000800
2350020000817
2350020000824
2350020000831
2350020000848
2350020000855
2350020000909
2350020000916
2350020000923
2350020001005
2350020001012
2350020001029
2350020001036
2350020001043
2350020001050
2350020001104
2350020001111
2350020001128
2350020001135
2350020001142
2350020001159
2350020001203
2350020001210
2350020001227
2350020001234
2350020001241
2350020001258
2350020001302
2350020001319
2350020001326
2350020001333
2350020001340
2350020001357
2350020001401
2350020001418
2350020001425
2350020001432
2350020001449
2350020001456
2350020001500
2350020001517
2350020001524
2350020001531
2350020001548
2350020001555
2350020001609
2350020001616
2350020001623
2350020001630
2350020001647