Skip navigation

divide text into columns

407 Views 5 Replies Latest reply: May 5, 2012 8:32 PM by Jerrold Green1 RSS
macfromnm Calculating status...
Currently Being Moderated
May 4, 2012 12:52 PM

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)
  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    May 4, 2012 1:00 PM (in response to macfromnm)

    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

  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    May 4, 2012 5:38 PM (in response to macfromnm)

    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

  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    May 5, 2012 8:32 PM (in response to macfromnm)

    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

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.