VBA Script

[addictedtopain]

Hi all,

I have the task to sort phone numbers in a list of contacts. The contacts have been imported into excel and I need to sort the phone numbers. There are a mixture of UK numbers and international numbers (mainly Russia)

The numbers either come in the following format

01232345434
+441232345434
+44 (0) 1232345434
+4401232345434
Or they have random spaces in between them or brackets around the 0


They need to be in the format of

+44 123 234 5434

Can anyone help me write a script to remove the spaces and brackets from the numbers, remove the 0s then append +44 Where needed, and add the spaces in the correct places

Thanks

 

[addictedtopain]

Don't worry guys I've been able to sort most of it removed the brackets with replace. and then used VBA replace script to remove the spaces. and then using a replace VBA script replaced all +440 with +44. Now I just need to sort a vlookup function to sort out the area code