Formula to add to nos

[lchungwe]

I wish to add 1 or 4 or 7 or 2 to nos in the posiition

eg

1347 become 1344 or 1341 or

1347 become 1317 or 1377 or

1347 become 1647 or 1947 or

1347 become 4347 or 7347

 

[lchungwe]

How to add potential nos to list in table but append to columns

2499 ---> 2899 or 2199 or 2466 or 5499
3678 ---> 3675 or ....
1248
0169
0367
0468
1256
1267
1368
3889
4999
5568
6777
0148
0889
1146
1235
1357
1477
1489
4579
4668
4899

 

[GlennUK]

Your request is not clear, and your examples are not consistent. If you want help on this please explain exactly what you require.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.