In Excel, is there a way to concatenate a large number of cells by defining a range rather than including each individual cell reference?
For example, suppose you want to concatenate the range, A1:A99. To my knowledge, there are two ways to do that but both involve including every single cell reference in the formula:
It sure would be helpful to have some function of the form:
which gives the same result.
Is such a function available?
The obvious follow-up, if such a function does exist, is whether or not there is a way to define a connector. For example, suppose you want the same range above to be concatenated but include a connector such as an underscore:
Is it possible to do that?