Copy/Paste multiple line cells results in double quotes

[dhancy]

I have a spreadsheet with a single column and several hundred rows. Some of those cells (not all) have text on multiple lines. For instance:

abc
xyz

When I copy/paste all cells in this column into something like notepad, those with multiple lines are surrounded by double quotes and look like this:

"abc
xyz"


How can I prevent the double quotes from showing in the resulting document?

Thank you!

Dennis

 

[Yongle]

Try putting this formula in adjacent column and paste returned values into Notepad

=TRIM(SUBSTITUTE(SUBSTITUTE(A1,CHAR(10)," "),CHAR(13)," "))

It will probably get rid of all the double quotes but are you happy with the resultant values in Notepad?

 

[dhancy]

Try putting this formula in adjacent column and paste returned values into Notepad

=TRIM(SUBSTITUTE(SUBSTITUTE(A1,CHAR(10)," "),CHAR(13)," "))

It will probably get rid of all the double quotes but are you happy with the resultant values in Notepad?

Thanks for your reply!

The good news is that the double quotes are gone. But now both lines appear on one line.
Is there anyway to preserve the multiple lines and not have the quotes?

 

[Yongle]

Another way ...
- paste original data (with resultant double quotes) to Notepad
- (in Notepad) replace quotes with nothing (Edit \ Replace )

If there are double quotes in Excel to be retained
... (in Excel) replace double quotes with XXXX
... paste to Notepad
... replace auto-generated double quotes with nothing (as above)
... replace XXXX with double quote

 

[dhancy]

Another way ...
- paste original data (with resultant double quotes) to Notepad
- (in Notepad) replace quotes with nothing (Edit \ Replace )

View attachment 33029

If there are double quotes in Excel to be retained
... (in Excel) replace double quotes with XXXX
... paste to Notepad
... replace auto-generated double quotes with nothing (as above)
... replace XXXX with double quote

Well I discovered one thing. If I paste this into Word, there are no double quotes.

For my immediate purposes, this works great, as I don't need to use notepad.