Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
This function works to combine the data of two cells in Excel.
Please participate and answer this question.
this is a concatenate equation if u have value1 in i9 and value2 in cell j9 so the answer will be1--2
It will contatinate values in cell I9 and J9 in the target cell.
copy this =I9 &"-"&J9 in A1 then put some data in I and J9.
& is a concatination operator. This adds 2 strings to one. Here value in I9 is concatinated with J9 with "-" between them.
It concatenates data from two different cells.
This is called concatenate function in excel and the purpose is to combine the text in the two cells together.
It is a substitute of concatenate formula. Above formula will write value of I9 (Cell reference) followed by "-" and then followed by value of J9 (cell Reference)
Its simply combines data of two reffered cells, separating by any special character used between " ", even space.
It will convert the data in two referenced cells into text with a space in between.
It is simply the function to join two alphabet or digits easily which are in two different places