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 Extensions → Text To Table Converter → Mega Tools → Text Case Transform (Smart Case).

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

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

Tip

The “Ignore Words” feature is perfect for protecting specific formatting like “iPhone” (won’t become “Iphone”), “ID” (won’t become “Id”), or company names like “McDonald’s” (won’t become “Mcdonald’s”).

Large Ranges

For ranges larger than 5,000 cells, a warning will appear before processing. You can choose to proceed or cancel. Destructive changes require preview confirmation for large ranges to prevent accidental bulk changes.

---

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

Input	Without Exceptions	With Exceptions
iphone 13 pro max	Iphone 13 Pro Max	iPhone 13 Pro Max
customer ID is 12345	Customer Id Is 12345	Customer ID Is 12345
made in usa	Made In Usa	Made In 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

Looking for AI?

For context-aware capitalization that understands names, addresses, and product titles without manual exceptions, see Smart Text Case.