Forum Discussion
Susanna Hughes
May 25, 2017Copper Contributor
Help for CONCATENATE function
Hi - I am using the CONCATENATE funcation to combine several cells into one. I would like a hard return (Alt+Shift) after each cells data. Is this possible? I knowt hat I can edit the formula...
Detlef_Lewin
May 25, 2017Silver Contributor
Hi
=TEXTJOIN(CHAR(10),TRUE,G1641:G1648)