Apostrophes - This will remove any apostrophes that occur within values (e.g. “John's Business”).


The following Matrix Design will remove all hyphens from CompanyName1, Address, ZIP & ContactName



When you select these options, you will instantly see the removal of these characters on the Data Preview window.


Once you have created the Matrix for your dataset, you can then run the entire cleaning process by clicking the Run Clean button.