Strip stray whitespace before the welcome merge runs
Onboarding's CSV from the ATS dropped a row with leading, trailing, and a doubled internal space in the new hire's name. Clean it before the 4pm merge so the email salutation isn't garbled.
Clean an imported new-hire name
Practice using TRIM to solve a real hr & operations problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
Onboarding pulled a CSV of next week's new hires from the ATS. The first row has stray spaces — leading, trailing, and a doubled space in the middle. You need a clean version before the welcome email merge runs at 4pm.
In cell C2, return a fully cleaned version of A2. No leading or trailing whitespace, single space between first and last name. Drag the formula down through C6 so the whole roster is cleaned.
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.