View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Concatenate range (without UDF)

Greg,

Probably yes but you may need to explain more. Try

=A1&B1&C1 etc

Mike

"Greg Lovern" wrote:

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