• Home
    • About
    • Services
      • All Services
      • Google Spreadsheet Automation
      • Google Docs
      • Google Forms
      • Google Calendar
      • Gmail
      • Google Drive
      • MS Excel Automation with VBA
      • MS Excel Formulas & Template Designing
      • API & Third party Integration
      • Data Visualization
    • Products
      • Sutra Tools
      • Mail Merge Sutra
      • Reconciliation Sutra
    • Contact Us
  • Contact Info

    • Ahmedabad , India
    • ---
    • support@sutraanalytics.com
      • Home
      • About
      • Services
        • All Services
        • Google Spreadsheet Automation
        • Google Docs
        • Google Forms
        • Google Calendar
        • Gmail
        • Google Drive
        • MS Excel Automation with VBA
        • MS Excel Formulas & Template Designing
        • API & Third party Integration
        • Data Visualization
      • Products
        • Sutra Tools
        • Mail Merge Sutra
        • Reconciliation Sutra
      • Contact Us
    Sutra Analytics
    Sutra Analytics
    • Home
    • About
    • Services
      • All Services
      • Google Spreadsheet Automation
      • Google Docs
      • Google Forms
      • Google Calendar
      • Gmail
      • Google Drive
      • MS Excel Automation with VBA
      • MS Excel Formulas & Template Designing
      • API & Third party Integration
      • Data Visualization
    • Products
      • Sutra Tools
      • Mail Merge Sutra
      • Reconciliation Sutra
    • Contact Us

    Cart

    How to Change Case In Google Sheet

    Sutra Analytics > Blog > Sutra Tools > How to Change Case In Google Sheet
    • Sutra Tools

    Many times we need to change the case like upper/lower/proper/capitalize each word/toggle in Google Sheets.
    This can be done by formulas. But wait !! what if you want to change the case with multiple cells with an active selection.

    This will require knowledge of formulas & it has to be written formulas multiple times for each cell.

    This tool will help you to change the case like upper/lower/proper/capitalize each word/toggle in active tab selection.

    CLICK HERE to Install the addon.

    How to Open Functionality:

    • First of all open the Google sheet then go to Extension > Sutra Tools > Utilities > Change Case like the below screenshot:

    Use of Functionality:

    • This Functionality is to use only the current tab Active selection range list.
    • After clicking on Change Case it shows 5 more options:
    1. Upper: Converts string to uppercase in active tab range list
    2. Lower: Converts string to lowercase in active tab range list
    3. Proper: Converts string to proper case(the first letter of the string will be capital) in active tab range list.
    4. Capitalize Each Word: Capitalizes each word to uppercase in string in the active tab range list
    5. Toggle: Converts string to toggle(upper to lower and lower to upper) in active tab range list


     

    Tags: excelgoogle sheet

    Leave a Reply Cancel reply

    Your email address will not be published. Required fields are marked *

    Mail Merge Sutra Contents

    Getting Started Mail Merge Sutra
    FAQ & User Guide Mail Merge Sutra

      Contact Us

      • C-906 Ganesh Glory 11, Nr. BSNL Office, Jagatpur, Ahmedabad, Gujarat 382470
      • +91 79840 99467
      • support@sutraanalytics.com
      • 10:00 AM To 7:00 PM

      Navigation

      • Home
      • About Us
      • Services
      • Portfolio
      • Blog
      • Contact Us

      Copyright 2022 - 2023 - Sutra Analytics PVT LTD., All rights reserved.