Level 2Text, Part 2Practice, 3 min
SUBSTITUTE: a clean UTM campaign name
The task
UTM campaign names should be lowercase with dashes instead of spaces. In B2, turn the campaign name in A2 into one. Watch out: someone left a space at the end.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | |
|---|---|---|
| 1 | Campaign | utm_campaign |
| 2 | Summer Sale Retargeting | |
| 3 | Back to School Search |