hp owner Posted December 27, 2014 Share Posted December 27, 2014 How to remove Double Quote Character automatically added by CHAR(10)?I am having one Excel 2010 Sheet as follows:A1=I loveB1=MS ExcelA2=I LoveB2=MS OfficeI have used C1=A1&CHAR(10)&B1 and C2=A2&CHAR(10)&B2.My requirement is to get the result asI loveMS ExcelI LoveMS OfficeWhen I am copying C1 and C2, I am getting"I loveMS Excel""I LoveMS Office"i.e. one Double Qote is automatically added at Strating and Ending of each cell.How to remove them? Link to comment Share on other sites More sharing options...
Dodel Posted December 28, 2014 Share Posted December 28, 2014 Either try changing for the format of the cell, or try removing the first and last " with =RIGHT(A1, LEN(A1)-1) for example. Link to comment Share on other sites More sharing options...
hp owner Posted January 7, 2015 Author Share Posted January 7, 2015 Not working. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.