Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
How do I insert a line feed in a formula? | Excel Worksheet Functions | |||
displaying output of a formula to be in double quotes | Excel Worksheet Functions | |||
Problem: Copying a cell that contains line breaks adds extra quotes | Excel Discussion (Misc queries) | |||
copy/paste excel to texteditor -> multi-line text cells gain unwanted double-quotes | Excel Discussion (Misc queries) |