View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Help with Concatenation

Help needed to concatenate 11 cells on same sheet, all of them in
the same row into two. Of the 11 cells, only max of 2 in each row
are filled out, others are left blank. How can I concatenate these
11 cells into 2 for each row?


If I understand your question correctly, just link the with ampersands.
Assuming we are talking about the first 11 columns...

=A1&A2&A3&A4&A5&A6&A7&A8&A9&A10&A11

Rick