Concatenate range (without UDF)
Thanks, I did mean concatenating a range reference, because the range
is dynamic, so I can't effectively reference individual cells.
I don't know why Microsoft lets things like this go unimproved version
after version after version. A similar annoyance is that AND and OR
are not array-aware.
Greg
On Sep 16, 9:09*am, "T. Valko" wrote:
Yes, but you have to reference each cell in the range individually.
=A1&B1&C1
=CONCATENATE(A1,B1,C1)
If you mean something like:
=CONCATENATE(A1:C1)
Then, no, can't be done with only built-in functions.
|