If I copy a row of text from a table and try to paste that row in the same, or any other table, the entire row of text is pasted into one cell in the destination table.
I cant figure out why this is happening or how to prevent it. Hoping someone can help.
MacBook Pro
Numbers uses a delimiter character to "know" how to decide when to move the next cell.
the delimiter character is a tab
the delimiter for a new row is a new line character
so if you are having trouble with text staying in the same cell, copy and paste the text into a text editor, then replace the existing delimiters with a tab
Do you have any apps that assist with keyboard stuff or with copy/paste or the clipboard? In other words, any app that might affect what goes onto the clipboard during Copy or how it Pastes; any app that runs in the background that has anything to do with the keyboard or clipboard? There have been problems in the past due to these apps and Numbers.
You do not have to do anything special to copy/paste between tables in Numbers. All you need to do is single click to select the destination cell that will be the top left cell of the ones to paste into. Do not double click the cell. When you double click you are entering "text edit" mode and it will paste all the text from the clipboard into that one cell, as you have discovered.
I am asking the screenshot I asked you to post be remove because there is personal information in it.
I should have asked you to make sure there was no such information. When posting things like, this I suggest making up fake names and changing numbers
are you able to share a MODIFIED version of the source file? If you are, please email the file to the first letter of my first name at my last name dot net.
I will try on my side to see if I can duplicate the issue and suggest a way to fix it.
One suggestion is to paste into text edit, then copy from there to Numbers.
Another suggestion is to paste into a new mail, then copy from there to Numbers.
I'm still getting the same result. The weird this is this does not happen every time. It's inconsistent.
can you (will you) post representative data and some screenshots?
I'm copying the contents of row 11and trying to paste into row 8 - but everything goings into one cell
[Image Edited by Moderator to Remove Personal Information]
I’m making sure not to double- click in the destination cell.
very frustrating
Do you see the cursor blinking in the cell before you paste?
No - cursor does not blink, but the end result is the same either way. I tried it with the cursor blinking, after double-clicking. The result is exactly the same.
That's it!
I use copyless - quit that and numbers copies A-OK!
Thanks for the solution..
Numbers pastes a row of text into one cell
