Skip to main content
SheetTutor.
SheetTutorLearn Excel by playBack to task

Build and inspect line-separated address labels

Your goal: Use actual LF characters, compare compact and fixed-slot joins, then inspect an ASCII marker without losing the original text.

Full 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.

Four address lines with one truly empty slotTurn the code into a marker0 cells selected
Quoted fields expose stored \r and \n. Visual wrapping is separate from a stored line break. Checked helpers keep their coordinates.ASCII marker code · B6: 65
Click or drag source cells; selected cells change color Drag from selected cells to deselect.
#
1
2
3
4
5
6
7
8
9
10
Step 1 of 9

Turn the code into a marker

Select the source cells in the worksheet, then check your selection.

Rules for this step

Choose the stored numeric code and predict the character CHAR returns.

Your result in E2
0 cells selected