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?


3 replies

    • Birger_H
    • 5 yrs ago
    • Official response
    • Reported - view

    Try it like this:

    street + "
    " + City + " " + Province

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


      • Admin.7
      • 1 yr ago
      • Reported - view

      Birger H was really simple at the end ! thanks for the solution !

    • C90Go!
    • Frederico_R
    • 4 yrs ago
    • Reported - view

    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.

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 3Replies
  • 2984Views
  • 1 Following