Build and inspect line-separated address labels
Fill E2:E10 separately. B2:B5 accept true blanks or nonempty Unicode text up to 40 code points, without embedded control characters. Preserve every literal space. B6 is a numeric whole printable ASCII code 33..126. E2 is CHAR(B6), E3 is its CODE round trip. E4 joins nonempty address slots with LF; E5 retains four fixed slots. E6 counts compact lines (zero for an empty result), E7 fixed line positions and E8 the first stored LF code read from E5 with MID after the first source line. E9 joins the marker and compact address with LF and E10 replaces those LF separators with space-pipe-space. Wrapped cells show the text in the actual grid; stored results and exports are checked independently.
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
Fill E2:E10 separately. B2:B5 accept true blanks or nonempty Unicode text up to 40 code points, without embedded control characters. Preserve every literal space. B6 is a numeric whole printable ASCII code 33..126. E2 is CHAR(B6), E3 is its CODE round trip. E4 joins nonempty address slots with LF; E5 retains four fixed slots. E6 counts compact lines (zero for an empty result), E7 fixed line positions and E8 the first stored LF code read from E5 with MID after the first source line. E9 joins the marker and compact address with LF and E10 replaces those LF separators with space-pipe-space. Wrapped cells show the text in the actual grid; stored results and exports are checked independently.
No account. No upload. Just try it.