Hi. I’m trying to create YouTube video descriptions by using the CONCATENATE function in Numbers on my Macbook Pro. I have one sheet where different parameters are entered, and a second sheet that will build the video descriptions by concatenating those values. I can’t figure out how to add a line break inside of the CONCATENATE function. I searched Google, but I could only find the solution for Excel, which would use CHAR(10) for a line break. Is there any way to do this in Numbers? Thanks!!!
I’m trying to do this because I need to create 16 YouTube video descriptions at a time, and wanted to use Numbers to automate the task. By inputting the needed parameters once in the first sheet (kind of like filling out a form), I wanted to have all 16 of the video descriptions created automatically in the second sheet.