Day 77 · Monday, 19 October 2026
SUBSTITUTE erases one punctuation character at a time, so a number carrying two kinds of separators needs two nested calls to come out clean — and once they're gone, LEN counting what's left is the simplest way to catch one that was never typed in full.
You're prepping a batch of customer phone numbers for a dialer system, and the CRM export has them with a space after the area code and a dash before the last four digits. The dialer only accepts bare digits, so in column C strip both characters out with SUBSTITUTE to get a clean, digits-only number. Then in column D, use LEN together with IF to flag whether each cleaned number came out to a valid 10 digits — "Yes" if it did, "No" if it didn't. Fill in rows 2 through 5.
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.
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.