Customer list clean-up
Fix an exported customer list: stray spaces, random capitals and duplicate rows, then turn it into a proper Excel table.
1. Download your workbook
Each download has its own data, so your answers are yours alone.
2. Do the work in Excel
- Remove the duplicate rows. Select the data, then choose Data > Remove Duplicates. Some customers were exported twice.
- Clean the names. In column D, add formulas that remove extra spaces from the name in column A and give it proper capitals, such as =PROPER(TRIM(A2)).
- Clean the emails. In column E, add formulas that remove spaces from the email in column B and make it lowercase.
- Make it a table. Click in the data and press Ctrl+T, or choose Insert > Table, so it sorts, filters and grows properly.
Save the file as an Excel Workbook (.xlsx) when you’re done.