Concat Fields with Carriage Returns

=A2&IF(B2<>"",CHAR(10)&B2,"")&IF(C2<>"",CHAR(10)&C2,"")

Convert All Zips Variants to Leading Zeroes

=SWITCH(LEN(A2),4,TEXT(A2,”00000″),5,A2,8,TEXT(A2,”00000-0000″),9,TEXT(A2,”00000-0000″))