View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CarlT CarlT is offline
external usenet poster
 
Posts: 1
Default Line Feed in Formula Adds Double Quotes?

I am trying to use a formula to create multiline text that I can copy and
paste into another application. The problem is the pasted text always comes
enclosed in double quotes which are not in the cell in Excel (and which I do
not want).

Cell A1 contains "CustomerName" (without quotes, I just typed CustomerName
directly into the cell).

Cell A2 contains "String" (again without the quotes)

Cell A3 contains the following formula:
="Public Property " & A1 & " As " & A2 & CHAR(13) & CHAR(10) & "End Property"

In Excel, cell A3 (when formatted to wrap lines) shows:
Public Property CustomerName As String
EndProperty

....just like I want it, on two separate lines. But when I select cell A3 and
copy, and then go to Notepad and paste, it appears in Notepad like this:
"Public Property CustomerName As String
EndProperty"

Where are these double quotes coming from and how can I get rid of them?

Thanks for any help or thoughts!

-Carl