Scrub the vendor names: line breaks AND whitespace
Compliance pulled the approved-vendor list from a PDF and the export carried two kinds of garbage: embedded line breaks (CHAR(10)) and messy whitespace. TRIM alone leaves the line breaks; CLEAN alone leaves the extra spaces. The audit needs the names to render as one readable line.
Full scrub: line breaks AND whitespace from a PDF export
Practice using TRIM to solve a real finance & accounting problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
Compliance pulled the approved-vendor list from a PDF and the export carried two kinds of garbage: embedded line breaks (CHAR(10)) AND messy whitespace. TRIM alone leaves the line breaks. CLEAN alone leaves the extra spaces. The audit briefing is tomorrow morning and the names need to render as a single readable line.
In cell C2, return a fully scrubbed version of A2. No embedded line breaks, no leading or trailing whitespace, single spaces between words. Drag the formula down through C9 so every vendor row renders cleanly.
TRIM removes leading and trailing spaces from text and collapses any run of internal spaces down to a single space. The one-function pre-flight check before any lookup, comparison, or join - because imported data from CRMs, PDFs, and web scrapes is almost never as clean as it looks.
TRIM(text)Try the formula first. Hints cost CP for a reason.