Hi

I have an export from a database which is giving me mobile phone numbers in a column. When input, some of these phone numbers were input with spaces, whereas some were not. We need to be uniform and remove all spaces.

Current = 027 123 4567
required = 0271234567

1) Can this be easily done without manually editing each cell?

2) The second phase of this is to remove all of the prefixed '0'

required = 271234567

3) The last phase is to add +64 as a prefix

required = +64271234567

In relation to 3) above I assume I use merge cell facility but am stuck on 1) and 2)

help would be appreciated

thank you