Cleaning data, whether it is your own or someone else's, is usually the most difficult and painstaking part of data analysis. In spreadsheets it may involve going cell by cell to look for errors and inconsistencies followed by cutting and pasting which can also introduce errors. In this workshop, we will show you how to use R to clean, reformat and subset data quickly and without introducing the errors that Excel can be prone to. We will use real life messy weather data to demonstrate how to use the power of R to arrive at a clean and manageable data set.