Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Mission

Mission: clean up the customer list

The customer list from the web shop is a mess: extra spaces, odd capitals. Clean it up and pull out what marketing asked for.

  1. Clean name. Marketing wants clean names, usernames and a few numbers. Work on row 2 (Anna) and in H2. Anna's name without extra spaces and with a capital at the start of each word, in E2
  2. Username. The part of Anna's email before the @, in F2
  3. Sign-up year. The year Anna signed up, in G2
  4. Gmail users. How many customers have a Gmail address? In H2

← All lessons