3

In cell A1 I have the value:

test

in cell C1 I have the formula:

=A1 & CHAR(10) & "attempt"

when I copy the value of C1 to Notepad++.exe it adds double quotes around the value.ie:

"test
attempt"

What will allow me to copy the formula (with my line break) so that no double quotes are added?

expected result:

 test
 attempt
slhck
  • 223,558
  • 70
  • 607
  • 592
toop
  • 355
  • 1
  • 6
  • 16
  • Related: http://superuser.com/questions/324271/how-to-copy-multi-line-text-from-excel-without-quotes – Ellesa Sep 29 '11 at 13:42

1 Answers1

0

I guess this is default Excel behaviour.

slhck
  • 223,558
  • 70
  • 607
  • 592
toop
  • 355
  • 1
  • 6
  • 16