This is a little bit faster way to merge data in excel than using concatenation formula.
In order to prevent this, select the full column by selecting the column header (Column D in our case) and press CTRL + C in Windows or Cmd + C on Mac to copy entire column.If you remove the obsolete columns ( First Name or Last Name), then the data in the merged column ( Full Name column in our case) will be lost. The new merged data column created is a result of formula iteration.
For example =CONCATENATE(B4,” “,C4, ” – “, E4) which will result as Brijesh Sharma – B+