Data Cleaning VB Macro script required

Job ID: 31384591

Budget: $10 – $30 USD

We need a Macro VB script to Clean data in Excel File. Data is consists of Pharmaceutical and chemical products.

Removal of extra spaces in cells
Removal of Special characters
Other than product name should be removed
Format of date must be sync
Management of missing entries
Customer name should be synced

Sample data is attached