Line Feed in Formula Adds Double Quotes?

C

CarlT

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
 
J

julie kothari

I use ASAP Utilities which is a free pack of Excel macros - just Google it. Under Export, there is a function called Copy Selection As Values. That copies everything except the double quotes to the clipboard. I assigned that function to Shift-Control-C and it works like a charm.



CarlT wrote:

Line Feed in Formula Adds Double Quotes?
21-Mar-10

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

Cell A1 contains "CustomerName" (without quotes, I just typed CustomerNam
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 Strin
EndPropert

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

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

Thanks for any help or thoughts

-Carl

Previous Posts In This Thread:

Line Feed in Formula Adds Double Quotes?
I am trying to use a formula to create multiline text that I can copy an
paste into another application. The problem is the pasted text always come
enclosed in double quotes which are not in the cell in Excel (and which I d
not want)

Cell A1 contains "CustomerName" (without quotes, I just typed CustomerNam
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 Strin
EndPropert

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

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

Thanks for any help or thoughts

-Carl


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Report Engine, Part 1
http://www.eggheadcafe.com/tutorial...74-4eba5c821311/wpf-report-engine-part-1.aspx
 
J

julie kothari

I use ASAP Utilities which is a free pack of Excel macros. Under Export, there is a function called Copy Selection As Values. That copies everything except the double quotes to the clipboard. I assigned the function to Shift-Control-C and it works like a charm.



CarlT wrote:

Line Feed in Formula Adds Double Quotes?
21-Mar-10

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

Previous Posts In This Thread:

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

Double quotes when using line feed
I use ASAP Utilities which is a free pack of Excel macros - just Google it. Under Export, there is a function called Copy Selection As Values. That copies everything except the double quotes to the clipboard. I assigned that function to Shift-Control-C and it works like a charm.


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Datagrid as ComboBox Dropdown Part 2
http://www.eggheadcafe.com/tutorial...96-e24127040bbf/wpf-datagrid-as-combobox.aspx
 
J

julie kothari

Sorry for the double post



julie kothari wrote:

Double quotes when using line feed
09-Apr-10

I use ASAP Utilities which is a free pack of Excel macros. Under Export, there is a function called Copy Selection As Values. That copies everything except the double quotes to the clipboard. I assigned the function to Shift-Control-C and it works like a charm.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
File-Based Cache for Web and non-Web Apps plus Extend ASP.NET 4.0 OutputCacheProvider
http://www.eggheadcafe.com/tutorial...dfe-9f7a28f4d58e/filebased-cache-for-web.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

char(10) and double quotes 2
Extract Formula to Text 6
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 1
Help Creating Excel Formula 4
Concatenate HTML containing double quotes 4
excel formula 1
A function that returns the formula of a cell as a string 9
Formula/Sum Question 2

Top