View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
johne johne is offline
external usenet poster
 
Posts: 40
Default char(10) and double quotes

When I put in the following, I get the expected result in the cell. However,
when I cut and paste the cell value to notepad or any other text editor I get
double quote marks around text.

="line1"&CHAR(10)&"line2"

Shows no double quotes markes in Excel, but cut and paste to notepad shows
double quote marks:

"line1
line2"

Is there a way to prevent these superfluous double quote marks when doing a
cut/paste to a text editor?