Separate text to different columns

Separate text to different columns

To change text to columns:

  1. Select the required cell or column which consists of the text you want to move to separate columns.

  2. Click Data > Text to Columns. The Text to Columns dialog box appears.

      3. Choose the delimiters such as comma, space, tab, etc. that you want to set to split the text into columns.

      4. Set the destination columns for moving the text.

      5. Click OK. 

    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

                                                          • Wrap text

                                                            Select the cells in which you want the content to be wrapped. Click on the Wrap Text icon  on the quick access tool-bar. Alternatively, click on the Format menu and select Wrap Text.
                                                          • Change the text color

                                                            To change text color Select the cells for which you want to color the font. On the tool bar, click the Text Color icon .  Choose the required color. The selected font color is applied to the selected text. To get a preview of the colors, hover over ...
                                                          • Freeze rows/columns

                                                            To freeze first row/column Click View > Freeze First Row or Freeze First Column. To freeze panes Place your selection on the cell, the rows and columns before which you wish to freeze. Click View > Freeze Select how much of your view port you want ...
                                                          • Rotate the text in a cell

                                                            To rotate text, Select the cell/cell range you want to rotate the text in. Click on the cell rotation icon  on the tool bar. Choose how much you want to rotate the text.
                                                          • Hyperlink data in a cell

                                                            To insert hyperlinks: Choose the desired cell/data. Go to  icon Under the Insert menu, choose Link. Choose the type of link to insert, and enter the URL/cell range/Email ID, respectively. To display a different text on the cell, enter the desired ...



                                                          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