View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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