Copy and paste from excel to notepad

D

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?
 
A

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
 
B

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.
 
B

Bob I

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

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.
 
D

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?
 
B

Bob I

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top