combine two cell values use of concatenate function
Learn how to combine two cell value in excel with use of concatenate function. We can also use & to join to two or more cell value. If A1 Cell value is My and B1 Cell value is Book, we have type =A1 & B1 in C1 cell, it will return MyBook, we can give space here also use of =A1 & ” ” & B1 formula, then output will be My Book. Text Function
Read more