CleanMySheet guide
Trim whitespace in spreadsheet cells
Trim whitespace collapses internal spaces and strips edges. Unify empty values is a separate step that maps N/A, NULL, -, and similar placeholders to a true blank so you can toggle them independently.
Open the cleanerSteps
- Upload
- Apply Trim whitespace
- Apply Unify empty values if placeholders remain
- Export
Why two steps?
Analysts sometimes need to keep the letters N/A as a category. Splitting trim from empty-unify keeps that choice in the recipe.
Related searches this page answers
- trim whitespace csv
- remove extra spaces excel
- trim cells online