CONCATENATE() & SUBSTITUTE() in MS EXCEL

I'm using Microsoft Excel for formatted my data sheet. 

I want to merge few cells data to a one cell. The way of I do this

I want to remove some selected values in a cell. The way of I do this