Split a pasted log into rows and fields
Enter one formula in G5. Split the text in A2 at | between fields and LF between records, normalizing CRLF pairs first. Preserve empty fields and records, spaces and text types. Pad shorter records with empty text to the widest record. An empty A2 returns No records. Up to eight records and three fields fit G5:I12; the exact result dimensions count.
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. Split the text in A2 at | between fields and LF between records, normalizing CRLF pairs first. Preserve empty fields and records, spaces and text types. Pad shorter records with empty text to the widest record. An empty A2 returns No records. Up to eight records and three fields fit G5:I12; the exact result dimensions count.
No account. No upload. Just try it.