Hi,

I am having an excel sheet containing a list of area codes, all in one column (a) such as 1210,1211,1212,1213,1214,1215,1216....1219
i want to summaries this to 121, now as per the above example there may be some area codes which may not include everything from 0 to 9, and some which do include 0 to 9 breakout.
for example the column contains as below
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1221
1224
1228
1220
need output like below
121
1221
1224
1228
1220
(121 containd all the digits trailing it 0 to 9, 122 doesnt, hence 121 10 rows remove and 1 row with just 121 added, 122 doesnt containg a trailing 0 to 9, hence kept as it is)

any help on this really appreciated.
apologies as searching from the forum and goole didnt turn up with any thing relevant, maybe i didnt use the right keywords

-Rob