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.