carriage return between concatenated data
I am trying to create a concatenated cell with separate lines
This is the formula i am using, but it is not inserting carriage returns
=Name@row + CHAR(10) + Date@row + CHAR(10) + Accomplishment@row
it puts everything on the same line with a space between them. what am i doing wrong?