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