SheetFix

A small Google Sheets add-on. Select cells, pick an operation from the SheetFix menu, done.

Operations

UPPERCASEjohn smith → JOHN SMITH
lowercaseJOHN SMITH → john smith
Title Casejohn smith → John Smith
Sentence caseHELLO WORLD. THIS IS JOHN. → Hello world. This is john.
Invert CaseJohn SMITH → jOHN smith
Trim & Fix Spaces" John Smith " → "John Smith"
Remove Line BreaksJohn ⏎ Smith ⏎ London → John Smith London

Data safety

Install

The add-on source lives in apps-script/ in this repository: Code.gs, Transforms.gs and appsscript.json. Follow apps-script/README.md to paste them into Extensions → Apps Script and reload your sheet.