From the archive

Task:

You handle customer service for Cobalt Outfitters, a mail-order retailer. Every order number follows the same pattern — three letters for the sales channel, a dash, the four-digit year, another dash, then a five-digit sequence number, so WEB-2026-00458 was order 458, placed through the website. A colleague building a filter wants the channel and the sequence number split into their own columns rather than read out of the string by eye. Pull the channel into column B and the sequence number, as a real number, into column C.