User defined C function for string concatenation?

Answer 1

The term concatenate refers to the operation of combining two or more strings into a single string. For example, the concatenation of abc and def is abcdef. Excel provides a function named CONCATENATE that will concatenate a series of strings. This function suffers from several very significant deficiencies, making is an essentailly useless function. First, you must supply each text value to CONCATENATE; you cannot pass a range to CONCATENATE and have it concatenate all the elements in the range. A second definciency is that CONCATENATE provides no way to automatically include a separater character between each of the concatenated strings. Finally, CONCATENATE cannot be used in array formulas (see Array Formulas for more information about array formulas) to build a string based on conditional tests.

Given these deficiencies of the CONCATENATE function, you can just as well use the concatenation operator &. There is no advantage to using CONCATENATE.