View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Combining Row Contents!

Same concepts from my earlier post apply. Combine, B1, B2, B3 in a
formula in cell D1. Copy that formula to the bottom of the sheet.
Change to values. The resort the entire sheet. The extra rows will
move to the bottom so you can delete them.

- John