How to insert a "carriage return" in a formula?

Hi all.

In a "Customer" database, based on a YouTube video, I created a formula field that contains street address + City + Province.

I would like to have this "formatted";  in other words, street on one line, City and Province on another line, etc.

Is there a way to insert a "carriage return" in the formula?

Is this the way to achieve what I want?


Ninox Profile

Try it like this:

street + "
" + City + " " + Province

In other words: you add a carriage return ba giving a carriage return in quotation marks. 



Please note: Your Formula will return 'undefined' until you 'Save Changes', at which point the new text formatting will appear. Lots of trial and error discovering this one.