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.

 

 

Concatenate Function

Text Function

One comment

Leave a Reply

Your email address will not be published. Required fields are marked *