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 ...
Use the CONCATENATE function to put data from multiple columns together in a new one Using the concatenate formula in ...
With CONCATENATE, you couldn't work with arrays ... Notice the spaces on each side of the word "and" in the formula. Excel ...