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
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.
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.
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.
How to paste tab separated text to multiple cells in numbers?
