5 Replies Latest reply: May 5, 2012 8:32 PM by Jerrold Green1
macfromnm Level 1 Level 1 (0 points)

I imported a tab delineated file into numbers and it put it into 1 column. The manual shows a menu bar Item "Divide text into columns" that doesn't appear on my tool bar. What now?


iMac, Mac OS X (10.5.8)
  • 1. Re: divide text into columns
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    Mac,

     

    That's a new one on me. Could you give us the Chapter and Section of the manual where you found that? The page number would help if you're using the English edition.

     

    Jerry

  • 2. Re: divide text into columns
    macfromnm Level 1 Level 1 (0 points)

    Chapter 8, page 173, first diagram.

  • 3. Re: divide text into columns
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    Mac,

     

    Got it. Thanks for the explicit reference, that really helps.

     

    I think the User Guide is a bit misleading there. The Guide is referring to the text in a Text Box and how you can format the box to display text in multiple columns, as in a newspaper page.

     

    This feature doesn't parse your data into table columns, sorry. If you want to describe your data, we may be able to help with that.

     

    It may be simple. Let's try the simple approach. If you Select and Copy the tab delimited data, then switch to a Numbers Table, click ONCE in a table cell and Command-V. Your data should spread across columns. If you click twice in a cell all your data will go into one column when you paste.

     

    Jerry

  • 4. Re: divide text into columns
    macfromnm Level 1 Level 1 (0 points)

    Thanks, the simple approach work. Where in the world is the "click once to spread data, click twice to use one column" explained. I assume by clicking twice you are doing a substitution of the blanks in the cell.

  • 5. Re: divide text into columns
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    By clicking twice on a cell you are drilling into the text layer, so everything you paste goes into that cell alone. The tabs simply are interpreted as tabs in any text block.

     

    When you click only once you are operating in the same mode as when you are doing manual data entry where you type an entry and hit Tab to move to the next column.

     

    Jerry