Day 50 · Tuesday, 22 September 2026

From the archive

Beginner

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.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.