From the archive
Day 50
Tuesday, 22 September 2026
Split supplier PO references into order number and revision count
TEXTBEFORE and TEXTAFTER cut a string at a delimiter you name once, instead of a LEFT/RIGHT/FIND stack rebuilt for every format a supplier feed throws at you.
Task:
Procurement reconciles supplier order confirmations against the ERP every morning. The EDI feed sends each one as a single reference like PO-48213-REV2 — the purchase order number and how many times it's been revised, joined by a "-REV" the feed always uses. The nightly import needs those two pieces in separate columns. In B2, use TEXTBEFORE to pull the order number out of A2, and in C2, use TEXTAFTER together with VALUE to turn the revision tag into a number. Copy both down to 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.
- 52Day 52 · Thursday, 24 September 2026Decide who qualifies for tuition reimbursement from two rules that both have to clearLatest
- Day 51 · Wednesday, 23 September 2026Align contract renewal dates to month-end, then count down the months left
- Day 50 · Tuesday, 22 September 2026Split supplier PO references into order number and revision count
- Day 49 · Monday, 21 September 2026Schedule onboarding tasks a fixed number of working days from a start date
- Day 48 · Sunday, 20 September 2026Flag over- and under-budget departments in a quarterly variance report
- 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