Normalize and review structured reference codes
Your goal: Create a three-column audit that validates a declared ASCII code shape before extracting a four-character suffix.
Full 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.
Normalize case, preserve zeroes and identify malformed codesKeep the nonempty original records
\u00A0 marks NBSP. Keep leading zeroes and letter case visible while reviewing the original code.
| # | |
|---|---|
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 |
Step 1 of 8
Keep the nonempty original records
Rules for this step
Choose every nonempty original record. A space-only record stays active, and repeated spellings remain separate physical records.