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. Both combine text from multiple cells into one. According to ...