Clean spaces and line breaks in imported text
Your goal: Turn messy imported labels into readable text while making the cleaning rules explicit.
Full task requirements
Clean A2:A7 into B2:B7. Replace nonbreaking spaces, tabs and line breaks with spaces, remove other ASCII control characters, and collapse ordinary spaces.
Imported contact labelsClean source row 2
Quoted text preserves spaces. \u00A0 marks NBSP; \t, \r and \n mark stored controls.
| # | |
|---|---|
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 |
Step 1 of 6
Clean source row 2
Rules for this step
Keep words separated: replace NBSP, TAB, CR and LF with ordinary spaces before removing other ASCII controls. Then trim and collapse ordinary spaces; other Unicode spacing remains literal.