The default format ... and ZIP code into one cell. NOTE: CONCAT replaced CONCATENATE in Excel 2016, but both functions are still available. Note that CONCAT appears only under Formulas > Text ...