想帮老婆弄一个简易的表格,她基本不会用EXCLE,她的工作是把别人发过来的货号配货,可是别人总是发过来的乱七八糟的,她配货时间总是非常久而且会出错,所以想帮她弄一个,求高手教教我改怎么弄。以下是别人发过来的货号:
001,002,008,010,019,017,021,022,025,048,053,029,042,028,112,111,095,019,196,195,
229,448,431,459,432,261,011,012,013,014,
016,017,018,019,030,037,089,090,094,096,
101,102,104,129,128,131,162,152,432,443,
198,209,221,223,142,143,159,115,122,127,
087,095,111,058,074,080,037,054,005,022,
002,019,029,,031,,037,,038,,041,,056,087,093,
,095,,118,,129,,174,,184,,190,,214 , 260, 260, 260,
412.196..118..120..098.019..033..017..194..229..
108, 111, 112, 113, 115, 117, 118, 119, 120, 127,
128, 129, 135, 072, 075, 076, 077, 080,081, 091,
092, 097, 099, 100, 435, 441, 443,448, 453.228
185
191
252
119
049
433
261
264
266
102
别人发过来的是又乱又没有规则,符号也不统一,我该怎么弄才能让我老婆能傻瓜式的一键整理排序计数呢?
|