Friday, April 19, 2013

yogi_Write A Formula For Manipulating Text So That Result When Copied And Pasted Is Correct


                                          Google Spreadsheet   Post  #1144
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 19, 2013
user rajvivek :(http://productforums.google.com/forum/?zx=2q5ayujli6f4#!mydiscussions/docs/H5oSip5Ms8Q)
Unwanted double inverted commas when copying pasting text generated through a formula
I am using a formula which is giving the desired outcome in the cells. However, when i copy paste the text from cells to another place it comes along with a pair of undesired inverted commas.

The formula is : =substitute(A2; "."; "." & char(10))

The text in cell is : Hope you must be fine.
 and so on.

When i am copy paste from the cell to this place (or any other place) : "Hope you must be fine.
 and so on.
"
The desired outcome should be as it is in the cell even if i copy paste anywhere. 

Please click this link as i have put this in a publicly shared spreadsheet better understanding.

Thanks for the help!
---
Hi Yogi!

Thanks for your reply!

Sorry, if my post is not descriptive / clear enough. Though, as you asked, I have populated the spreadsheet with another example in the 3rd row, however, i do not understand how more data will help into that.

In the shared spreadsheet link of which i provided in the above post, when you copy cell C2, and paste the content somewhere else (not in the spreadsheet, but in google docs, gmail compose, or anywhere else), you will find the content is magically automatically surrounded by double inverted commas (" "). I don't want these inverted commas to come along with the text when copy pasted.

I hope it is clear enough now.
-------------------------------------------------------------------------------------------------------------------
following is a solution to the problem