JohnTravolski
New Member
- Joined
- Nov 25, 2015
- Messages
- 47
- Office Version
- 2019
- Platform
- Windows
Starting today, Excel is now putting quotes around every line of text copied from cells from a workbook when pasting into a plain-text application like Notepad or an editor like SSMS. I'm copying lines of SQL code from the excel workbook into the text editor and I'm getting lines that look like this:
This never used to happen. What changed? How can I prevent this from happening when copying text from Excel cells into a plaintext application? A workaround I found is copying into Word first and then copying form word back into the plaintext application, but this is stupid.
I'm on Excel 2412 Build 18324.20190, 32-bit
SQL:
"SET NOCOUNT ON; "
"if OBJECT_ID('tempdb..#temptable1') is not null begin drop table #temptable1; end; "
"Create Table #myTempTable "
This never used to happen. What changed? How can I prevent this from happening when copying text from Excel cells into a plaintext application? A workaround I found is copying into Word first and then copying form word back into the plaintext application, but this is stupid.
I'm on Excel 2412 Build 18324.20190, 32-bit