Format Fields for Address mailing lables
Hey guys, I hope someone can help me out with this.
I have 5 text fields for an address:
I need a calculation to format each field so that I have the address in one field.
What function can I use to look at each field and if there is not a comma at the end, to display the field with a comma on the end.
What function can I use so that if the field is empty it wont display the field in the address.
I have already used the Proper function and added carriage returns.
Basically at the moment some look like this:
They all need to look like this
or if empty field is present: