Day 101 · Thursday, 12 November 2026

From the archive

Beginner

Clean Up Payment References with UPPER and SUBSTITUTE

Customers type invoice numbers into their bank transfers however they like: lower case, capitals, spaces in the middle, a stray space at the end. Before those payments can be matched to the sales ledger they need one clean key, and two text functions make every version of the same reference read identically.

Task:

You do the morning bank reconciliation for a building-supplies wholesaler. This week's incoming transfers are in A2:D7, and column C holds the invoice reference exactly as each customer typed it. Your ledger stores references as capital letters with no spaces at all, like INV20417. In E2:E7, turn each typed reference into that form so it can be matched against the ledger.

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.