Day 38 · Thursday, 10 September 2026

From the archive

Intermediate

Split shipping addresses into city and state

TEXTSPLIT breaks text apart wherever a delimiter you name appears, so a multi-word city passes straight through untouched.

Task:

You handle order fulfillment for an online retailer. This week's shipping addresses came in from a legacy import as a single "City, State" string, but the label printer needs city and state in separate columns. In C2, split the address in B2 into City and State using TEXTSPLIT, then copy down through 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.