Apple Intelligence is now available on iPhone, iPad, and Mac!
I cannot paste tab-separated text to multiple cells in numbers on my mac.
The numbers version is 10.3.5 (7029.5.5)
For example, I have a text "a\tb\tc", where "\t" means a tab character.
When I paste it into numbers, it becomes below.
But it is expected to be
How can I make it?
MacBook Pro 15″, macOS 11.0
Interesting. Numbers will interpret it as a table and separate it into columns and rows like you desire if you have two lines like this (separated by tabs)
a b c
d e f
But it does not seem to do the same if there is just one row. I tried it with just a carriage return and no second row of data but it needs at least one "cell' in the second row to figure out it is a "table" being imported.
I do not have an answer at this time, just pointing out what I see happening. Maybe it is something obvious I am missing here.
Interesting. Numbers will interpret it as a table and separate it into columns and rows like you desire if you have two lines like this (separated by tabs)
a b c
d e f
But it does not seem to do the same if there is just one row. I tried it with just a carriage return and no second row of data but it needs at least one "cell' in the second row to figure out it is a "table" being imported.
I do not have an answer at this time, just pointing out what I see happening. Maybe it is something obvious I am missing here.
It appears it will separate it if it is rich text, not plain text. At this time the workaround I see is to paste the plain text into TextEdit (new TextEdit documents are formatted as rich text), then copy it from there and paste into Numbers.
How to paste tab separated text to multiple cells in numbers?
