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.


--
Biff
Microsoft Excel MVP


"Greg Lovern" wrote in message
...
Is it possible to concatenate a range using only Excel's built-in
worksheet functions?

Yes, I know it can be done in a UDF, and I can do that. I'm just
wondering if it's possible to do it in Excel's built-in worksheet
functions.


Thanks,

Greg