New line with CONCATENATE formula

Topic Labels: Sync
1644 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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”

1 Reply 1
10 - Mercury
10 - Mercury

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.


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