Split a code with LEFT, MID and RIGHT
33%
LEFTMIDRIGHT
LEFT takes characters from the start, RIGHT from the end, and MID from wherever you tell it. LEFT and RIGHT need to know how many; MID needs to know where to start as well.
MID counts the start position from 1, not 0. In INV-00421-X, the first character is the I at position 1, so the digits begin at position 5.
A2 holds INV-00421-X. Put the type in B2, the five-digit number in C2 and the final letter in D2.
The grid for this exercise needs a free profile.
Everything above is yours to read either way. 19 exercises stay open with no profile at all.