Usually in the excel if we use the formula we need to drag and use other cells too.

But in the concatenate not like that, so that i am just drag all the values but put ENTER manually in each cell to update the corresponding values.