I have a list of telephone numbers that have been changed to new ones.
I require a macro where when selecting a particular column/colums and running, the macro should pick up the 1st two digits ( 3 digits in some cases ) of the telephone number and change it in the following format below. Could it be done? Pls anybody help.
thanks a lot in advance
I require a macro where when selecting a particular column/colums and running, the macro should pick up the 1st two digits ( 3 digits in some cases ) of the telephone number and change it in the following format below. Could it be done? Pls anybody help.
thanks a lot in advance
Book23.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | old number | new Number | ||||
2 | 23 | 563 | ||||
3 | 25 | 205 | ||||
4 | 46 | 566 | ||||
5 | 595 | 5595 | ||||
6 | 596 | 5596 | ||||
7 | 597 | 5597 | ||||
8 | 598 | 5598 | ||||
9 | 599 | 5599 | ||||
10 | 69 | 569 | ||||
11 | 79 | 559 | ||||
12 | ||||||
13 | example | |||||
14 | Old Number | New number | ||||
15 | 2301235 | 56301235 | ||||
16 | 2542514 | 20542514 | ||||
17 | 4605214 | 56605214 | ||||
18 | 5957445 | 55957445 | ||||
19 | 5967447 | 55967447 | ||||
20 | 5978475 | 55978475 | ||||
21 | 5988958 | 55988958 | ||||
22 | 5996544 | 55996544 | ||||
23 | 6952621 | 56952621 | ||||
24 | 7902225 | 55902225 | ||||
25 | ||||||
26 | ||||||
Sheet1 |