I'm having trouble with CONCATENATE formula writing to create "Full Address" on 2 lines (using CHAR10). Here's the formula I've written, for which I keep getting an error message (and yes, I have a main Street Address plus a Street Address 2, i.e., apartment # and the like as part of the first line of the address, before then having the 2nd line consist of city, state and zip): =CONCATENATE(AC,", ",AD,CHAR(10)AE,", ",AF," ",AG,)
Solved by G. B. in 18 mins