Is there a way to enter a manual line break in a concatenate formula?
For example, if:
Cell A1 = "Name"
Cell B1 = "Address"
Cell C1 = "City, ST Zip"
What would I need to enter in the concatenate formula so that cell A2 looked like this (regardless of column width of course):
Quote:
Name
Address
City, ST Zip
|
Obviously, the starting formula is:
=CONCATENATE(A1,B1,C1)
I tried looking through the help menu but couldn't find anything
ETA: Never mind. I tried out this really cool thing called "Google" and it helped me find the answer: CHAR(10)
The formula would be:
=CONCATENATE(A1,CHAR(10),B1,CHAR(10),C1)