Getting rid of quotes when copying from excel.

[tmsmyer]

I need some help for when I am copying data from a cell and pasting it into a text box on a website. Every time I copy the cell and paste it, it has quotes at the beginning and end of the data string that I have to manually delete. Is there a way to do this so it does not paste the quotes? Below is my formula:


=(CONCATENATE(helper!A15," ",CHAR(10),helper!A16," ",CHAR(10),helper!A17," ",CHAR(10),helper!A18," ",CHAR(10),helper!A19," ",CHAR(10),helper!A20," ",CHAR(10),helper!A21," ",CHAR(10),helper!A22," ",CHAR(10),helper!A23," ",CHAR(10),helper!A24))


I have tried using the =CLEAN function, but that gets rid of the carriage return, which I also need.

 

[Micron]

Apparently this is a quirk whereby M$ decided multi line text means you want the cell values to be csv text. Pasting into Word removes them for me. I don't think you'll have to use Paste Special and select a non-html format - I don't. Seems the only solution is a work around where you paste into Word then copy from there. Notepad doesn't work.