Normalize and review structured reference codes
Enter one formula in G5. Keep nonempty A2:A9 records in source order, replace NBSP with ordinary spaces, then TRIM ordinary spaces. Validate the cleaned source as exactly two ASCII letters, one hyphen and four ASCII digits, with length seven. Display UPPER(cleaned), Ready or Review, and the four-character text suffix only for Ready records. A cleaned blank record is still Review. If there are no source records, return No records.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter one formula in G5. Keep nonempty A2:A9 records in source order, replace NBSP with ordinary spaces, then TRIM ordinary spaces. Validate the cleaned source as exactly two ASCII letters, one hyphen and four ASCII digits, with length seven. Display UPPER(cleaned), Ready or Review, and the four-character text suffix only for Ready records. A cleaned blank record is still Review. If there are no source records, return No records.
No account. No upload. Just try it.