0 of 62
Text·Scenario·Lesson 45 of 62Pro

Clean a contact list for a mail merge

A real-world job using what the Text section covered.

What you’ll do

A bakery collected these sign-ups at a market stall and on its website. The names and emails are messy. You’ll clean them up and get everything ready for a newsletter.

The steps

5 steps
  1. 1
    In E2, clean up the name in A2: no extra spaces and a capital at the start of each word. Fill it down to E11.
  2. 2
    In F2, remove the stray spaces around the email in B2. Fill it down to F11.
  3. 3
    In G2, pull out the first name from the clean name in E2. Fill it down to G11.
  4. 4
    In H2, build a greeting like Hi Ana, from the first name in G2 (with the comma). Fill it down to H11.
  5. 5
    In J2, list every clean email in one cell, separated by a comma and a space, ready to paste into an email.

Scenario locked

Unlock the other 44 lessons for $49.99

Pro opens every drill, practice set, scenario, project and section review. One payment, yours to keep.

Unlock for $49.99