| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 123811 | 2012-03-18 00:38:00 | adding nz prefix to excel column of cellphone numbers | GameJunkie (72) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1265582 | 2012-03-18 00:38:00 | so i've got a column of cellphone numbers in excel in the format of 027XXXXXXX etc etc what i need to do is remove the 0 and replace it with 64 so it reads 6427XXXXXXX is there a quick formulaic way to do this or is it a case of changing each number manually?? thanks GJ |
GameJunkie (72) | ||
| 1265583 | 2012-03-18 00:47:00 | 027123456 6427123456 In column B: =CONCATENATE("64", RIGHT(A1, LEN(A1)-1)) |
somebody (208) | ||
| 1265584 | 2012-03-18 00:55:00 | Highlight the column (click on the column header). Then CTRL+H (find and replace). Find 027 and replace with 6427. Might be an issue if you have 027 somewhere other than the start where you want to make the change. |
ManUFan (7602) | ||
| 1265585 | 2012-03-18 01:20:00 | @ somebody: thanks for that, all sorted now @ManUFan: should've mentioned there was a mixture of 027, 021 and 022. thanks anyway |
GameJunkie (72) | ||
| 1 | |||||