Copy and paste from excel to notepad

[DV]

I am trying to copy and paste 2 cells from an excel spreadsheet into notepad
and have them go on separate lines. My problem is when I copy and paste them
they go on the same line in notepad. Can someone help?

 

[DV]

I should also add that this is when the 2 cells are in the same row.

 

[Bob I]

Press enter after placing the cursor between the pasted cell contents.

 

[DV]

I need it to paste on separate lines. Any ideas?

Press enter after placing the cursor between the pasted cell contents.

 

[Another Brian]

The only options that I can think of are:
1) Paste both which will put them on the same line and them manually
add a new line, or
2) Cut one cell and paste it. Press enter then cut-n-paste the second
line.

I don't think that what you are trying to do can be done.

Brian

 

[Bob I]

It WILL be on separate lines then. You NEED a CR and LF to have the
second line. If you move the two cells ABOVE one another before you copy
them, THEN when you paste they will be on two lines because that will
put the CR/LF in. But copy adjacent cells will only put in a Tab.

 

[DV]

Can i do it if i put it in the same cell? If so, how?

 

[Bob I]

After you paste it to Notepad put the cursor at the point you want the
line break and press enter.

 

[DV]

i cant do that. i am using notepad as an example but the application that i
really need to paste it into does not allow me to hit enter after paste..it
has to paste it that way.

 

[Bob I]

Then you will need to set it up correctly BEFORE you copy.

 

[DV]

I actually can do the 2 lines using a formula like
=W25&CHAR(13)&(CHAR(10))&Y25 but the problem now is when i paste it into
notepad it puts quotes around the text..any ideas about that?

 

[Bob I]

Since you say notepad is only an example and isn't what you are going to
use anyway, what does it matter?