Hello, I am using the CONCATENATE formula to concatenate texts coming from different cells plus custom text. Is there a way of starting a new line after the additional text? The formula I used is CONCATENATE(“ITALIANO”,cell_n.1, “ENGLISH”,cell_n.2) and I would like to start a new line after “ITALIANO” and “ENGLISH”
Hi Giorgia. Yes, you can do this with ‘\n’. Take a look at the formula below. I’m using the ‘&’ to concatenate instead of the function. For example, let’s use “scimmia” and “monkey”, adding a new line after the word ‘ITALIANO’ and ‘ENGLISH’ would make your field look like this.