You're preaching to the choir!

--
Biff
Microsoft Excel MVP


"Greg Lovern" wrote in message
...
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.