If you just need to merge two empty columns together, use Excel's Merge option. CONCAT vs. CONCATENATE in Excel With Excel 2016, Microsoft replaced the CONCATENATE function with the CONCAT function.