From the archive
Day 38
Thursday, 10 September 2026
Intermediate
Split shipping addresses into city and state
TEXTSPLIT breaks text apart wherever a delimiter you name appears, so a multi-word city passes straight through untouched.
Task:
You handle order fulfillment for an online retailer. This week's shipping addresses came in from a legacy import as a single "City, State" string, but the label printer needs city and state in separate columns. In C2, split the address in B2 into City and State using TEXTSPLIT, then copy down through row 5.
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