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. 


    • Related Articles

    • Format a text

      Apply various text styles and effects to make your presentation content look impressive. With the Zoho Show app for Android, you can change the color of text to match with your brand, list ideas using bulletin or numbered list style, add superscript ...
    • Format a Text

      Text placed on your slide inside a text box, placeholder, shape, or picture can be made to look appealing, legible, and expressive to the eyes of your audience by using a variety of text formatting styles. To emphasize a piece of business jargon, you ...
    • Customize columns

      Customize columns You can customize columns in the issue List view based on your preference. Click  and choose Customize Column. Select Default View or Compact View. Compact View shows more issues than the Default View. Select the desired columns to ...
    • Add, Edit, and Delete Table Rows and Columns

      Add a table  Putting tables into your presentation helps you summarize, group, and present data in an organized way and compare various market values and trends in an easily understood way. A table represent data within a grid of cells arranged in ...
    • Removing and Reordering Columns

      Admins and column owners have access to remove columns from all users' views. To remove a column: Go to the Monitor tab. Scroll to the column you want to remove and click the ellipsis (...) button in the upper right. Click Remove this column. ...