Pasting multiple lines of text into a cel?!?

Question

Pasting multiple lines of text into a cel?!?

I know that I can enter multiple lines of text into a cell by using [Alt][Enter] at the end of a line.
If I then copy-paste all the text to (say) a field in a FM database and copy-paste it back later (or into a different Numbers document) the lines will not stay together in one cell, but are becoming seperate cells for each line.

Is there a way to copy-pastea multiple line text into one cell? This is actually quite important to me, as I'm using this for quote sheets of multiple lines of products with specs...

Thanks a lot,

Allart van Holten

Many, Mac OS X (10.6.6)

Posted on Mar 9, 2011 9:58 AM

Reply

Answer 1

Badunit

Level 7

30,348 points

Mar 9, 2011 12:00 PM in response to Allart Van Holten

Double click the cell before pasting.

Reply

Answer 2

Mar 9, 2011 12:04 PM in response to Allart Van Holten

Allart,

Generally speaking, if you click once on a cell you will highlight the cell but will not activate the Text Insertion feature. I think this is what you are doing now when each "Paragraph" from the copied data goes to a new row.

If you click twice on the cell, you will have drilled down to the text layer and now when you paste everything will most likely go into that cell only.

I think it could be more complicated than that depending on your data arrangement, but I recommend giving it a try to see if you like the result. Or, at least you may get a better understanding of what is going on.

Jerry

Reply

Answer 3

KOENIG Yvan

Level 8

41,819 points

Mar 9, 2011 3:35 PM in response to Jerrold Green1

Personal message for Jerrold

I don't know if you received the mail which I sent you about App Store.
If you did, please send a response.
I wait for it before responding to Apple Bugs Hunters.

Thanks in advance.

Yvan KOENIG (VALLAURIS, France) jeudi 10 mars 2011 00:34:57

Reply

Answer 4

Mar 9, 2011 6:00 PM in response to KOENIG Yvan

Thank you Yvan. I responded by email.

Jerry

Reply

Answer 5

Mar 10, 2011 12:02 AM in response to Allart Van Holten

As always, the solution was right there (and once I knew it, it was an obvious soltion)

Thanks for your help.

Allart

Reply