Data Entry/Cleaning need done ASAP

Heya, I need some data cleaning done ASAP

Taking the address Data. and Changing the format to be formatted for Mailchimp - about 1500 contacts

https://mailchimp.com/help/format-guidelines-for-your-import-file/


Changing the Country Code (United Kingdom is GB)

10 Compass court, Scarborough, Ontario, CANADA
to
10 Compass court Scarborough Ontario CA

Double checking the spacing - i.e.
12A Tower 1 Manhattan Hill 1 Po Lun Street Hong Kong Hong Kong 0000 HK
to
12A Tower 1 Manhattan Hill 1 Po Lun Street Hong Kong Hong Kong 0000
... in effect using a double space inbetween each line of the address

Removing Commas, and replacing them with Double spaces

200 Aldersgate , Aldersgate Street, London, EC1A 4HD, UK
to
200 Aldersgate . Aldersgate Street London EC1A 4HD GB

Removing all periods.

76. Upper Ground South Bank London. SE1 9PZ GB
to
76 Upper Ground South Bank London SE1 9PZ GB



Need to be done ASAP