Skip to Content
Former Member
Jul 12, 2007 at 05:32 AM

Combine addresses


Post Author: leongcy23

CA Forum: Formula

Hi all,

I have a situation here where I need to combine all the field like Address1, Address2, Address3, Zip, City, State, Country in one formula. My formula is like this : {ContSupp.ADDRESS1}" "{ContSupp.ADDRESS2}" "{ContSupp.ADDRESS3}" "{ContSupp.ZIP}" "{ContSupp.CITY}" "{ContSupp.STATE}" "{ContSupp.COUNTRY}

But I find that the formula won't work if I leave either one of the field empty. It only work when all the field are filled in. If I use if-else function, it will be a long list of formula.

Anyone got any idea on this? Appreciate for help. Thanks