MIS-Interview Series-Q8
MIS-Interview Series-Q5 Question was asked in MIS Interview. https://youtu.be/CiEq4Oi4HsI
Read moreTag: concatenate function in excel
Extract First Name From A Cell In Excel
I have to extract first name from a cell in excel. हमें एक्सेल में एक cell से first नाम निकलना है. Here we have only one logic that from start to end, what is the position of first space in cell, we have deduct 1 in that position, then from left side we will pick number character with help of left function to extract first name. यहाँ हमें […]
Read morecombine 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