Copy Excel cell contents wo/ newline

Thyme

Platinum Member
Nov 30, 2000
2,330
0
0
Is there a preference anywhere to make it so when you have a single cell selected and copy, it doesn't include a new line? It's incredibly inconvenient to select the insides manually. (As if the rest of the Excel UI doesn't make me want to kill myself)
 

DnetMHZ

Diamond Member
Apr 10, 2001
9,826
1
81
You mean for example you copy a cell in excel then paste it in notepad and your cursor ends up on the next line?
 

ravana

Platinum Member
Jul 18, 2002
2,149
1
76
Only thing I can think of is

Copy cell,

go to word->edit->paste special->Plain text

Save as .txt

otherwise, I cant see any way to do it other than using a macro/vbscript.
 

Thyme

Platinum Member
Nov 30, 2000
2,330
0
0
Yeah. Mainly I was wondering if there was an option I didn't know about. I'll probably write a macro or just deal with it. Thanks.