We would like an Excel formula to convert a phone number please.
For example we would like to convert 642040061368 to 0204 006 1368 - all numbers to be converted are like this.
Here is a link to a demo sheet with more detail to show what we want which and a formula can be placed.
| Input | Desired Output |
|---|---|
| 642040061369 | 0204 006 1369 |
| 642040061365 | 0204 006 1365 |
| 642040061224 | 0204 006 1224 |
| 642040061222 | 0204 006 1222 |
| 642040061363 | 0204 006 1363 |
| 642040061374 | 0204 006 1374 |
| 642040061368 | 0204 006 1368 |
| 642040061372 | 0204 006 1372 |
| 642040061385 | 0204 006 1385 |
| 642040061183 | 0204 006 1183 |
| 642040061179 | 0204 006 1179 |
| 642040061366 | 0204 006 1366 |
| 642040061193 | 0204 006 1193 |
| 642040061192 | 0204 006 1192 |
| 642040061238 | 0204 006 1238 |
thanks heaps