Spreadsheets

Question

Level 1

6 points

Spreadsheets

I have a spreadsheet in Numbers/08. I am 'copy and pasting' some of the columns into another format in Pages. I want to merge two of the columns from Numbers into one when I put them in the Pages format, which means there will be 2 names in each of the merged cells. I want them one name beneath the other in each cell but when I try to do this, one name just eradicates the other. How do I get both names in the one cell?

iMac, Mac OS X (10.5), Leopard

Posted on May 29, 2009 10:14 AM

Reply

Answer 1

Best reply

Ashka

Level 4

3,885 points

May 29, 2009 7:58 PM in response to enaid 204

To put two or more names into a single cell one under the other:

Select name is second column cell ~ command c to copy
select cell in first column > put curser after first name ~ option return to put in a carriage return > command v to paste name into cell.
S.

Reply

Answer 2

enaid 204 Author

Level 1

6 points

May 30, 2009 12:25 PM in response to Ashka

Thank you so much for this. I have spent days trying to figure it out.

Reply

Answer 3

May 30, 2009 7:18 PM in response to enaid 204

enaid,

This method might be less work for you if you have many cells to convert:

The expression for the "1 over 2" column cells is: =A & CHAR(10) & B

Regards,

Jerry

Reply

Answer 4

enaid 204 Author

Level 1

6 points

Jun 1, 2009 12:52 PM in response to Jerrold Green1

Thanks for this. I'll try it out. After the first try, the previous method suggested stopped working for me. Whenever I press command c to copy, the name is deleted and I just get a "c". I can't understand what I'm doing wrong.

Reply

Answer 5

Jun 1, 2009 5:45 PM in response to enaid 204

+After the first try, the previous method suggested stopped working for me. Whenever I press command c to copy, the name is deleted and I just get a "c". I can't understand what I'm doing wrong+.

enaid,

I quiver at the thought of that much manual labor, so I haven't tried it. I did try my suggestion, as you can see.

Jerry

Reply