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.




--
Invoice

=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
>