View Single Post
  #1  
Old June 3rd, 2010, 04:24 PM posted to microsoft.public.excel.worksheet.functions
Leporello
external usenet poster
 
Posts: 1
Default Function to concatenate cells in a range

Does anyone have an elegant way of concatenating a series of cells? I think
the answer will be a user defined function which will be equivalent to
MULTICONCAT(start cell : end cell). I think it needs to be a function rather
than a macro, so that I can include it in formulae elsewhere in the workbook.
I can manage with the limitation of the contents of the cells of a single
row or a single column, but it would be nice to have something which was a
bit more versatile and could handle a two dimensional array or, best of all,
non-contiguous cells.