Telephone numbers - Remove leading zeros or replace 07 with 447

This might be a tricky one!

I have a list of UK and non-UK telephone mobile numbers. The non-UK numbers start "00" and the UK numbers start "07". What I want to do is make all the numbers the same, i.e. country code and number - for example 447777555000 for UK or 353444999777 for Ireland.

Please can someone help?

Thanks!

I would keep them with the leading zeros.

Can you explain why you want to change them?

Pete

I want to do a comparison with another list which has no leading zeros which is why I need to remove the zeros. So 1 list has the international telephone number (no leading zeros) and the other list has UK mobiles (starting 07) and foreign mobiles (starting 00).

It's OK, I've worked it out - ended up with:

=IF(LEFT(D2,2)="07","447"&RIGHT(D2,LEN(D2)-2),IF(LEFT(D2,2)="00",RIGHT(D2,LEN(D2)-2),(D2)))