Stray leading or trailing quotes
What they are and how to fix them
What are stray leading or trailing quotes?
Stray quotes appear when cells start or end with extra quote marks that are not part of the intended value. They cause failed matches and inconsistent display. RxLint detects and helps remove these quote artifacts.
Example data with this issue
| name | status |
|---|---|
| "Alice"" | active |
| 'Bob | inactive |
| Carol" | active |
Frequently asked questions
Are all quotes in spreadsheets bad?
No. CSV quoting is valid when used to escape delimiters. The issue is unintended quote characters left in the actual data value.
How does RxLint fix stray quotes?
You can apply a quick fix to strip leading and trailing quote characters from all affected cells.