Lab › Data Cleaning

Data Cleaning: Excel Lab

Fix spaces and case, split names, build email IDs. Pick a lab. Watch how, then do it yourself.

Clean Messy Names

Names came in with extra spaces and MIXED case. Make them clean: one space, first letter capital.

Make an office email ID (first.last@company.com) and initials for every employee.

Split each full name into a first name and a last name.