Copying from excel - Quotation marks not required
Posted on 2010-04-06
When I copy the result of a formula from excel to another application, normally it copies as-is. But if the resulting text contains a char(10) then the text copied is enclosed in quotes when pasted. This is the formula I am using
="-insert "&VLOOKUP(IF(LEFT(C12,3)="HR ","HR",C12),Sheet2!$A$1:$B$1000,2,0)&CHAR(13)&G12&","&$J$10&" "&$I$10&" "&IF(E12="R",180,0)
presently I am copying the text to notepad and replace the quotes then copying from notepad to the application which is quite a nuisance.
How can I get rid of this and be able to directly copy to my application.
BTW my application is Autocad.