The directory import puts Main and Entrance on separate lines in one cell. Replace the break with a space so the words stay separate when you use the label in a report.
Replace the line feed before trimming
For a test, use ="Main"&CHAR(10)&"Entrance" in A2. In B2 enter:
=TRIM(SUBSTITUTE(A2,CHAR(10)," "))The helper should read Main Entrance. If the import has carriage return and line feed pairs, replace both with spaces before trimming:
=TRIM(SUBSTITUTE(SUBSTITUTE(A2,CHAR(13)," "),CHAR(10)," "))
Illustrated import cleanup. Keep the source next to the helper.
Check a label that already fits on one line
Try Side Entrance and confirm it stays the same. Check the cleaned label for a space between the words. Keep intentional line breaks in the source, such as a mailing address, and use the helper only where you need a one-line label.

Illustrated comparison. Avoid removing the separator without replacing it.



