Trim spaces

Trim spaces

You can use Trim spaces to remove the excess whitespace in the column data.

To trim excess whitespace:

1. Right-click the column name and select the Trim spaces icon from the context menu. 
2. Trim can be used to,
  1. Remove the following,
    1. Leading whitespaces
    2. Trailing whitespaces
    3. Empty lines
  2. Convert the following:
    1. Line breaks to space
    2. Continuous spaces to one space
    3. Tabs to spaces
    4. Spaces to tabs
    5. Spaces to line breaks
    6. Continuous empty lines to one empty line
    7. Continuous tabs to one tab
3. You can select more than one checkbox to perform multiple trim operations at the same time and then click Apply.

 4.  To apply this transformation to multiple columns, select the 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

                                                        • Functions available to add formula columns

                                                          Abs abs(num) Returns the absolute value of the numeric value. Parameters Name Description num Decimal Parameter must be a numeric value from a column or an expression that returns a number. Example Function Result abs(-1) 1 Div ...



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


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


                                                        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