Excel Study · Module 5: Text functions
Class 39LEFT, RIGHT & MID
Intermediate1:54 videoFree
An order code like IN-2024-0457 hides three things: the country, the year and the order number.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A2 has an order code like IN-2024-0457: a country, a year and an order number. Write a formula for E2 that gives the year. It must work in Excel 2016.
The answer that works
✓ checked in Excel=MID(A2,4,4)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.