Change case

Change case


You can change the case of texts in a column using one of the following options:
  1. Upper case (E.g., ZOHO IS THE OPERATING SYSTEM FOR YOUR BUSINESS)
  1. Lower case (E.g., zoho is the operating system for your business)
  1. Title case (E.g., Zoho is the Operating System for your Business)
  1. Camel case (E.g., ZohoOffersAPowerfulSuiteOfSoftwareToRunYourEntireBusiness)
  1. Alternating case (E.g., TrAnSfOrMaTiOn)
  1. Invert current case style (E.g., TRANSformation → transFORMATION)
  1. Sentence case (E.g., Zoho is the operating system for your business)
  1. Capitalized case (E.g., Zoho Is The Operating System For Your Business)

To perform Change case operation:

1. Right-click a text column and select the Change case option from the context menu. 

2. Select one of the options from the operation panel under the Change case to option. 



3. You can apply this transformation for multiple columns. Select columns using the  icon under Columns to apply.

    Zoho DataPrep Personalized Demo

    If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

    Zoho CRM Training

      Create, share, and deliver

      beautiful slides from anywhere.

      Get Started Now





              Zoho CRM Training Programs

              Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

              Zoho CRM Training

                Zoho SalesIQ Resources



                    Zoho TeamInbox Resources




                              Zoho DataPrep Resources

                                Zoho DataPrep Demo

                                Get a personalized demo or POC

                                REGISTER NOW


                                  Design. Discuss. Deliver.

                                  Create visually engaging stories with Zoho Show.

                                  Get Started Now











                                                        • Related Articles

                                                        • Change data type

                                                          Zoho DataPrep automatically identifies the data type of each column in your dataset during the time of import. Sometimes due to multiple errors in the dataset, DataPrep may not correctly identify the data type, in which case you can manually override ...
                                                        • Change date format

                                                          DataPrep offers a wide range of predefined date and time formats.  Choose to apply a predefined date-time format from the template or create your own custom format.  Your custom format is saved to the template and can be used again in the future. To ...
                                                        • Change number format

                                                          DataPrep allows different regional formats for numbers. For example, in India, one million is written as 10,00,000 whereas, in the United States, it is written as 1,000,000. To change the format of numerical values: Right-click the numerical column ...
                                                        • Creating custom data type

                                                          Custom data types are used to validate organization-specific data, such as employee ID, invoice ID, shipment tracking ID, or asset ID. By creating a custom data type, you can set a standard for your organization-specific columns in your data. This ...
                                                        • Find and Replace

                                                          Find and replace values in your column using the replace transform. You can find the value to replace by matching the value using different options available and replace it with your input. To find and replace column data: 1. Right-click the column ...

                                                        Resources

                                                        Videos

                                                        Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                        eBooks

                                                        Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                        Webinars

                                                        Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                        CRM Tips

                                                        Make the most of Zoho CRM with these useful tips.



                                                          Zoho Show Resources