Hey, I'm copying some text and pasting it to Numbers.
About 4 times after pasting the text, a pop up window showed called Import settings, which I need. But now it doesn't show.
I'm importing the same thing, from same page, same form of the text etc. Nothing changed, just the Import setting don't show up anymore. How to get to this settings?
Thank you!
J
Hi J,
Do you mean this pop-up?
Click on the table to select it, then in the Format panel > Table tab, drag up to see this at the bottom:
Regards,
Ian.
Yes this pop up.
Unfortunately, when the pop up doesn't show, I can't even find it under "Format panel > Table tab".
Looks like some text is just "pasted" and some "imported". Just guessing, have no idea.
Hi J,
Yes, that feature applies only to imported tables, not pasted tables. (Doh! I should have paid more attention to your original post!)
JakLes wrote:
I'm copying some text and pasting it to Numbers.
My first thought was pasting a table containing text. Or am I wrong?
What is your overall aim? How do you want to adjust text?
A screen shot will help us to see what you see. Delete or hide sensitive data before taking a screen shot.
Regards,
Ian.
Hey Ian,
So basically I'm trying to copy few recommended Categories from ChatGPT. I get it like this:
And then I paste it to Numbers.
If the pop up doesn't show it end ups like 1st row (Home Decor, Gardening, Health & Wellness).
If pop up does show up, I can set that after "," the text will continue in next cell. Like it is in 2nd line (Electronics & Tech | Retail)
So I'm aiming to split also the 1st line, which has 3 categories. So I would like to have it in 3 seperate cells.
Does it make sense?
Please also note it's not probably about what text I'm copying as I copied this categories before and I didn't have this problem...
J
Hi J,
I am flummoxed. I tried changing commas into tab characters, then copying and pasting into a Numbers table. I see the same result. Everything in the same column.
The only way I can see (and this is a pain in the ****) is to copy the text, open TextEdit and paste.
In TextEdit, Menu > Format > Make Plain Text and Save.
Open the TextEdit document in Numbers to see the pop-up.
Tabs used to work 🤔.
It seems that Numbers has changed. I shall pass this "upstairs" and call on someone who is an expert at text to table.
Regards,
Ian.
Thanks for the tip. Better than nothing..
Let's hope they will fix that :)
I think part of the problem here is that csv format usually has the same number of items on each line. Here you have three in the first line and two in the second.
If I add a third item to the second line so the first two lines have the same number of items then I can paste into Numbers as expected.
SG
+1. This is how it must be done to spread evenly across columns upon paste (with Numbers v13.1).
Hey, thanks for the idea. Unfortunately that's not something which would work. Before I didn't have problems to copy lines which were 3, 2, 2, 3 categories. Picture attached.
JakLes wrote:
Hey, thanks for the idea.
Hi, it's not really an "idea." It's how csv generally works with most apps. For the data to import in a uniform way you will need the same number of items on each line, especially the first two lines.
SG
Numbers Import settings
