View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nick nick is offline
external usenet poster
 
Posts: 192
Default Concatenate question

I have a dynamic list entered in columns. I am trying to take one of those
columns and concatenate it into a single cell to be copied directly to a
separate form in the format required. My problem is that the list is dynamic
in both the number of records and the data. It is impractical to constantly
modify the concatenate statement that provides the final product to copy and
paste into my form. Is there any way to concatenate an entire column into
one cell like this dynamically?