Skip to main content

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”

Thanks

Giorgia

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.


ITALIANO

scimmiaENGLISH

monkey


Would you prefer it to be the following?


ITALIANO scimmia

ENGLISH monkey


If so, then you would use something like this…


'ITALIANO' & ' ' & cell_n.1 & '\n' & 'ENGLISH' & ' ' & cell_n.2


Either way, I hope you see how to use the ‘\n’. You must also have your cell height set to Med at least (in order to see the effect).

Reply


Terms & Conditions