From the archive
Day 42
Monday, 14 September 2026
Clean migrated customer names for a CRM import
TRIM strips out the spacing problems a copy-pasted export leaves behind, so nest it inside PROPER and PROPER only ever has to solve capitalization, never spacing too.
Task:
You're migrating customer records out of a 15-year-old CRM into a new cloud system for Bellwood Furniture ahead of the cutover. Years of staff copy-pasting between systems have left the name field a mess — some names are in ALL CAPS, some in lowercase, and most carry extra spaces at the start, the end, or doubled up between words. The new system's name field is capped at 20 characters, so before you load the list you need a properly capitalized, single-spaced version of each name in column B, and each one's character count in column C so you can catch anything too long to fit.
The daily challenge is part of Pro
A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.
Recent days
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.
- 48Day 48 · Sunday, 20 September 2026Flag over- and under-budget departments in a quarterly variance reportLatest
- Day 47 · Saturday, 19 September 2026Bill only the memberships that are actually still active
- Day 46 · Friday, 18 September 2026Price a pick list against a supplier catalogue that no longer lists everything
- Day 45 · Thursday, 17 September 2026Find how much to deposit today to cover a multi-year scholarship payout
- Day 44 · Wednesday, 16 September 2026Report a fair "typical" salary when one outlier skews the average
- Day 43 · Tuesday, 15 September 2026Look up a placement fee from a category-by-level fee grid
- Day 42 · Monday, 14 September 2026Clean migrated customer names for a CRM import
- Day 41 · Sunday, 13 September 2026Sort machined shafts into Pass, Rework, or Scrap from two tolerance windows
- Day 40 · Saturday, 12 September 2026Weigh a GPA by credit hours instead of by course count
- Day 39 · Friday, 11 September 2026Report a call center's hold times without one outlier setting the headline number
- Day 38 · Thursday, 10 September 2026Split shipping addresses into city and state
- Day 37 · Wednesday, 9 September 2026Read a CD rate off a table laid out by term, not by row
- Day 36 · Tuesday, 8 September 2026Average order value for one channel and one region — then a threshold on top
- Day 35 · Monday, 7 September 2026Work out when equipment has to ship, counting backward from a start date