I have a string of text broken up in a range of contiguous cells. I'd like to use the concatenate function, but pass it a range parameter "=concatenate(A1:An)" instead of a list of "n" cell parameters "=concatenate(A1, A2, A3, A4, ...An)"
Anyone know a way to work around that? If you pass it a range as a parameter, it only takes the string from the first cell in the range, so in my example above, the output is the string that was in A1.
The problem is, the size of the range will vary from case to case, so it's a case where i need to pass a dynamically determined relative range reference, as opposed to a known number of parameters.
Anyone know a way to work around that? If you pass it a range as a parameter, it only takes the string from the first cell in the range, so in my example above, the output is the string that was in A1.
The problem is, the size of the range will vary from case to case, so it's a case where i need to pass a dynamically determined relative range reference, as opposed to a known number of parameters.