Pasting fields with newlines in Numbers

I have several fields in one column in Numbers on iPad, each containing internal newlines.


How do I copy those fields out of Numbers, all at once, so I can manipulate the text and paste the result back into Numbers?


When I try to copy from Numbers, I get


"Field data
More data"
"New Field
More data"


Which would be great, except that pasting it back into Numbers ignores the quotes and makes a new field for each newline. How to I convince Numbers to accept the data back again in the same form in which it left?


Alternately, tell me how to find and replace newlines; I want to change every newline to two newlines.



[Re-Titled by Moderator]

iPad Pro, iPadOS 17

Posted on Jan 26, 2025 12:26 PM

Reply
Question marked as Top-ranking reply

Posted on Jan 31, 2025 6:43 PM

Instead of clicking once to select the cell, double click the cell to enter text entry mode. Then paste.

3 replies

Jan 31, 2025 9:33 PM in response to Zarquon42

It will paste it into a single cell. I misunderstood what you wanted to do.


If they have quotes around them like shown in your post and you are editing it in a text editor, save it as plain text with a CSV extension (in other words, make it a CSV file). Open that file with Numbers and it will be in individual cells in one column. Copy/paste to your original document.


It is unfortunate that Numbers does not recognize it as CSV data when copy/pasted directly from the text editor


You can replace newlines with two newlines using Find (Command F). If you do Replace All it will replace every one it finds in the entire document. There is a Shortcut app shortcut that will Replace All in selected cells only, rather than everywhere. If you need it I'll provide a link to it.


This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Pasting fields with newlines in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.