CONCAT and TEXTJOIN were added to Excel in 2019, so if you're using an older version, you might not have access to these functions. In Short: CONCAT vs. TEXTJOIN Both combine text from multiple ...

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.