divide text into columns
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)
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)
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
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
Chapter 8, page 173, first diagram.
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
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.
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
divide text into columns