Newline being ignored

Oh, I forgot to mention that when query is loaded to sheet, you'll have to double click on cell to make CHR(13) active (SQL or most db does not display CHR(13) within field).

Sample query.

SELECT Trim(cnam05)+CHR(13)+
	Trim(cad105)+CHR(13)+
	Trim(cad205)+CHR(13)+
	Trim(cad405)+CHR(13)+
	Trim(cad505) AS 'caddress'
FROM `C:\Test\Source.xlsx`.`Sheet1$` `Sheet1$`

It will initially display as...
0.JPG

Double click on the cell.
1.JPG

Edit: If you want to apply to multiple rows, just copy format of first cell and apply to rest.