Currently Being ModeratedMay 4, 2012 5:38 PM (in response to macfromnm)
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.
Currently Being ModeratedMay 5, 2012 7:25 AM (in response to Jerrold Green1)
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.
Currently Being ModeratedMay 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.