Forum Discussion
address concatenation
=CONCAT(C87," ",B87,"
",D87,"
",E87)
does not return
andrew zinger
24 deauvill drive
dayton
rather it returns
andrew zinger24 deaville drivedayton
=CONCATENATE(B87,CHAR(10),C87," ",D87,CHAR(10),E87)You can try this formula and activate wrap text.
