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 moreWith Use of right function in MS Excel. We can extract some text from right side from a cell value. for Example:- If we have computer in A1 cell. With below formula we can extract 3 character from right side of call value Text Function
Read moreWith the help of Len & Substitute Function. We can found out how may words used in a Cell. Text Function
Read moreWith Use of left function in MS Excel. We can extract some text from left side from a cell value. for Example:- If we have computer in A1 cell. With below formula we can extract 3 character from left side of call value Text Function
Read more