How to remove Double Quote Character automatically added by CHAR(10)?

[hp owner]

How to remove Double Quote Character automatically added by CHAR(10)?

I am having one Excel 2010 Sheet as follows:

A1=I love

B1=MS Excel

A2=I Love

B2=MS Office

I have used C1=A1&CHAR(10)&B1 and C2=A2&CHAR(10)&B2.

My requirement is to get the result as

I love
MS Excel
I Love
MS Office

When I am copying C1 and C2, I am getting

"I love
MS Excel"
"I Love
MS Office"

i.e. one Double Qote is automatically added at Strating and Ending of each cell.

How to remove them?

[Dodel]

Either try changing for the format of the cell, or try removing the first and last " with =RIGHT(A1, LEN(A1)-1) for example.

[hp owner]

Not working.