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.
Like Follow
3replies
-
Try it like this:
–––
street + "
" + City + " " + Province
–––In other words: you add a carriage return ba giving a carriage return in quotation marks.
Birger
-
Birger H was really simple at the end ! thanks for the solution !
-
-
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.