Day 77 · Monday, 19 October 2026

From the archive

Advanced

Clean phone numbers with nested SUBSTITUTE and flag short ones with LEN

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.

Task:

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.

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.