New line with CONCATENATE formula

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).

2 Likes