Jan 31 2023 02:29 PM
=CONCAT(C87," ",B87,"
",D87,"
",E87)
does not return
andrew zinger
24 deauvill drive
dayton
rather it returns
andrew zinger24 deaville drivedayton
Jan 31 2023 02:42 PM
=CONCATENATE(B87,CHAR(10),C87," ",D87,CHAR(10),E87)
You can try this formula and activate wrap text.