Extra whitespace
What they are and how to fix them
What are extra whitespace?
Spaces at the start or end of a cell are easy to miss but cause failed lookups, duplicate matches for the same value, and messy exports. RxLint finds every cell with extra whitespace so you can trim them in one action.
Example data with this issue
| code | name |
|---|---|
| A1 | Apple |
| B2 | Banana |
| C3 | Cherry |
Frequently asked questions
Why is leading or trailing space a problem?
" London" and "London" are different strings. Joins and filters can miss matches, and exports can contain values that look the same but do not compare equal.
Can I trim all affected values at once?
Yes. RxLint lists affected cells and offers a quick fix to trim leading and trailing whitespace in one batch.