CONCAT text in Excel
Don't miss that the recent addition to the current version of Excel, the CONCAT formula, will let you easily combine the text of a range of cells.
The older CONCATENATE formula will give you an error if you attempt to combine a range of cells containing text or digits.
CONCAT lets you easily combine the contents of multiple cells. This is useful when you want to compare the entries on one row for differences on another row.