Text Case Transform

The Text Case Transform tool helps you normalize capitalization across your spreadsheet data with multiple case modes, including Smart Title Case that keeps minor words lowercase. It includes word exceptions to preserve specific formatting like brand names (iPhone), IDs, and acronyms.

How to use Text Case Transform

1. Open the tool

Open the add-on sidebar, expand Sheets Mega Tools, go to Cell Formatting, and click Text Case Transform.

You can also use the Sheets Mega Tools menu shortcut to open the same sidebar section.

2. Choose your scope

Select where to apply the transformation:

• Selection (default) - Transform only your current selection
• Current sheet - Transform the entire active sheet
• All sheets - Transform across all sheets in the workbook

3. Select a case mode

Choose from the visual grid showing each style:

• UPPERCASE - HELLO WORLD (all letters uppercase)
• lowercase - hello world (all letters lowercase)
• Title Case - Hello World (capitalize first letter of every word)
• Smart Title Case - Hello World (capitalizes major words, keeps minor words like "a", "an", "the", "of" lowercase unless they are the first word)
• Sentence case - Hello world (capitalizes only the first letter of the cell)
• Proper Case - Hello World (capitalizes first letter of every word, like Title Case)

4. Configure advanced options (optional)

Expand the advanced options panel to customize:

• Ignore Formulas - Skip cells containing formulas (default: checked)
• Ignore Numbers - Skip cells that are purely numeric (default: checked)
• Trim Whitespace - Clean up spaces before applying case (default: checked)
• Ignore Words (Exceptions) - Comma-separated list of words to skip (e.g., "iPhone, ID, USA, pH"). These strings will remain exactly as found, protecting brand names and acronyms.

5. Preview or Quick Apply
6. Preview Changes (Recommended) - Opens a results window showing Old Value → New Value for review before applying
7. Quick Apply - Only available for selections < 1000 cells. Bypasses preview for speed, with toast notification and Undo option

Case Modes Explained

UPPERCASE

Converts all letters to uppercase: "hello world" → "HELLO WORLD"

lowercase

Converts all letters to lowercase: "Hello World" → "hello world"

Title Case

Capitalizes the first letter of every word: "hello world" → "Hello World"

Smart Title Case

Like Title Case, but keeps minor words lowercase (except when they're the first word). Minor words include: a, an, and, as, at, but, by, en, for, if, in, nor, of, on, or, per, the, to, v., vs., via

Examples:

• "the quick brown fox" → "The Quick Brown Fox"
• "a tale of two cities" → "A Tale of Two Cities"
• "war and peace" → "War and Peace"

Sentence case

Capitalizes only the first letter of the cell: "hello world" → "Hello world"

Proper Case

Capitalizes the first letter of every word (same as Title Case): "hello world" → "Hello World"

Exception Handling

The Ignore Words list protects specific terms from transformation:

• Uses case-insensitive matching during search
• Preserves the exact casing found in your exception list
• Uses word boundaries to match whole words only
• Comma-separated format: iPhone, ID, USA, pH, CEO, MBA

Example

If you set exceptions to: iPhone, ID, USA

Preview vs Quick Apply

Preview Changes (Recommended)

• Shows before/after comparison table
• Highlights specific changes in green/red
• Required for selections > 1000 cells
• Allows you to review before committing
• Best for validating transformation logic

Quick Apply

• Only available for selections < 1000 cells
• Bypasses preview for faster application
• Shows toast notification with Undo option
• Best for small, trusted transformations

Use Cases

• Standardize headers - Normalize column headers before exporting or sharing CSVs
• Clean survey data - Fix inconsistent capitalization in user-submitted responses
• Product catalogs - Properly capitalize product names while preserving brand formatting
• Contact lists - Standardize names and addresses with Sentence or Title Case
• Clean pasted text - Fix text copied from emails, PDFs, or websites
• Brand protection - Use exceptions to preserve "iPhone", "iPad", "eBay", "LinkedIn" formatting
• Academic papers - Apply Smart Title Case to titles and headings

Advanced Tips

• Start small - For large datasets, test on a small selection first to validate your settings
• Use exceptions liberally - Add any brand names, acronyms, or special terms to the ignore list
• Smart vs Title - Use Smart Title Case for titles and headings where minor words should be lowercase
• Combine with Trim - Enable "Trim Whitespace" to clean up extra spaces at the same time
• Preserve formulas - Keep "Ignore Formulas" checked to avoid breaking cell calculations