Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

New line with CONCATENATE formula

Topic Labels: Sync
440 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Reply 1

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