Quick Calcs - Cleanup

Fastest way to do data cleanup

Data Cleanup

Lastly Subset is the easiest way to clean up your data. You can apply a LOWER, UPPER, PROPER, or TRIM function to any column you want by just clicking the quick calcs and selecting clean up.

These functions are helpful if you are trying to make your data more consistent.

Example of the different formulas applied to the Names column.