You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hey Gang, I need help pasting a list from TextEdit into one Numbers cell please. At present, it is splitting it per word per cell. I really need the list to appear in one cell only. I have tried paste (keep formatting), please help me out, what am I missing here :) thanks. x
iMac 21.5″, macOS 10.14
I cannot explain why it is splitting it into words across the columns. It is natural for it to split it into rows based on the presence of carriage returns. It would normally split it up into columns based on detecting it to be CSV data (comma separated values). Are the characters between the words spaces or something else?
You should be able to put it all in one cell if you double click the cell first to get it into "text edit" mode. You should see the cursor blinking in the cell. Then Paste.
I cannot explain why it is splitting it into words across the columns. It is natural for it to split it into rows based on the presence of carriage returns. It would normally split it up into columns based on detecting it to be CSV data (comma separated values). Are the characters between the words spaces or something else?
You should be able to put it all in one cell if you double click the cell first to get it into "text edit" mode. You should see the cursor blinking in the cell. Then Paste.
Amazing - thank you so much. Solved with 'text edit' mode!
Copy and paste a list in to one cell in Numbers
