carriage return between concatenated data

LorieT

I am trying to create a concatenated cell with separate lines

Name

Date

Accomplishment

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?

Paul Newcome

Try clicking on the "Wrap Text" button.