View Single Post
  #2   Report Post  
Marvin P. Winterbottom
 
Posts: n/a
Default

=concatenate(cell1, cell2, etc...)

"rosey1" wrote:

How can I create a formula to automatically transfer text from merged cells
on one worksheet to a single cell on another worksheet? This would operate
like a summary sheet with the data transferred automatically. I tried the =
and clicking on the merged cells but I keep getting a zero.