dimanche 19 avril 2015

How to concatenate columns in excel using a formula having conditions?

I want to concatenate columns A, B, C and D in column E. But the concatenated cell should contain the data of all the columns with some extra text. e.g. Suppose column A contains "11/01/1997", B contains "ABC", C contains "20" and D contains "B+". Then E should contain "DOB: (data of A column), Name: (data of B column)" and so on.


Aucun commentaire:

Enregistrer un commentaire