CONCAT and TEXTJOIN were added to Excel in 2019 ... meaning you'll end up with the same value or symbol placed between each item joined together. As well as those described above, there are ...

For example, 10 + 7 means 10 added to 7. It is also used as a concatenation symbol for text fields. For example, city + ", " + state combines the CITY field with a comma, blank space and the STATE ...