Exercises / Cleaning text · 5 of 13
Pull the year out of an invoice number
MID(text, start, n) returns n characters starting at position start. Position 1 is the first character.
Your taskInvoice numbers look like INV-2026-00412. In B2, use MID to return the 4-digit year, which starts at character 5. It will be copied down to B7.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B |
|---|---|---|
| 1 | Invoice | Year |
| 2 | INV-2026-00412 | |
| 3 | INV-2025-01877 | |
| 4 | INV-2026-00038 | |
| 5 | INV-2024-02290 | |
| 6 | INV-2026-01101 | |
| 7 | INV-2025-00754 |