How to use this tool
- Choose a text column such as City or Department and inspect a few original values.
- Trim the ends, collapse repeated spaces, change case, or find and replace a specific string. Apply one change at a time when the column contains names or codes.
- Review the preview, including accented names and meaningful punctuation, then apply and export.
Worked examples
| Original data | After review |
|---|---|
| “ North Office ” | “North Office” after trimming |
| “Sales Operations” | “Sales Operations” after collapsing spaces |
Frequently asked questions
Does trimming remove spaces between words?
Trimming changes the start and end of each value. Use the repeated-space operation if you also want to collapse multiple spaces between words.
Should I title-case every customer name?
Review exceptions such as McKay, van der Meer, and company initials. Capitalization alone cannot tell you a person’s preferred spelling.
