Cleansing Data for Message Media

Formating 300 rows of customer data to be used in Message Media automatic txt messaging service 1. Format telephone numbers by removing the 0 and adding +64 . Column E 2. Column B is only to have trading name information. Therefore shift address information to a new column, add any supplier information ( numbers like S/n 5400 or FON 7543 ) to Column C , if column c already has a number just remove). Remove the verticle lines that are separating trading name/address /supply number Be advised that some phone numbers have yet to be populated by my sales team. An example of the correct formats the yellow row in the Freelancer expert sample