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)," "))

The line feed between Main and Entrance is replaced with a regular space.

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.

Main Entrance keeps its space while Side Entrance stays as it was.

Illustrated comparison. Avoid removing the separator without replacing it.

Microsoft’s guidance on cleaning imported spreadsheet text