How to Cleanse Raw Data (FULL COURSE)
![](https://learning.necsu.nhs.uk/wp-content/uploads/2021/09/HtCRD-thumbnail-2.jpg)
There are probably far too many scenarios to cover to be able to adequately demonstrate every possible data cleansing technique. However, during this video, we touch upon a number of useful approaches which should help you arrive at more readable and sensibly formatted data sets.
The topics:
- Data cleaning using the CLEAN and TRIM functions
- Text substitution using the SUBSTITUTE and REPLACE functions
- Using the Flash Fill feature
- Extracting text using the SEARCH, LEFT and MID functions
- Techniques to remove duplicates
- Using the Text to Columns command to clean your data
- Converting dates from an American format
- Reformatting data which has become offset