Best Ways to cleanse the data using VBA

[Tuuuuu]

Greetings All,

Currently in my company I am facing problems in cleansing data as it comes from another department.
I would like the best Ways to cleanse the data using VBA.

Thanks,

 

[BigBeachBananas]

Your question is too general to be answered. Share sample data and your desired outcome.

 

[jkpieterse]

Cleaning data is nowadays best done using the Data tab, Get Data button.