Extract both sides of the final separator
Enter one formula in G5 to report nonempty A2:A9 records in source order. Split each at the last case-sensitive literal separator in F2. Keep the whole prefix and final field as text; either side may be empty. With no separator, return Review in both columns. Ignore genuinely blank/empty cells; space-only records remain. If no records remain, 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 to report nonempty A2:A9 records in source order. Split each at the last case-sensitive literal separator in F2. Keep the whole prefix and final field as text; either side may be empty. With no separator, return Review in both columns. Ignore genuinely blank/empty cells; space-only records remain. If no records remain, return No records.
No account. No upload. Just try it.