Concatenate and Line Breaks
 

Hi,

Normally, we can use Alt+Enter to add a line break to text we type into a single cell. Is something like this possible with the concatenate function?

I'd like to take texts from several different cells and put them together in one cell with line breaks where I want them.

Concatenate and Line Breaks
 

=CONCATENATE(A1,CHAR(10),A2)

and then format the cell to wrap
--
Gary's Student


"Invoice" wrote:


Hi,

Normally, we can use Alt+Enter to add a line break to text we type into
a single cell. Is something like this possible with the concatenate
function?

I'd like to take texts from several different cells and put them
together in one cell with line breaks where I want them.




--
Invoice