0

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?

Thanks.

3 replies

null
    • Birger_H
    • 6 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. 

    Birger

      • Admin.7
      • 2 yrs ago
      • Reported - view

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

    • C90Go!
    • Frederico_R
    • 5 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.

Login to reply

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 3Replies
  • 3101Views
  • 1 Following