4.9 08 Concatenate Function in MS Excel Concatenate function in MS Excel is an important and simple function, which can be learned easily. It is used to join two or more strings (Text) to make one string. Let us understand the syntax first: text1: It is a mandatory field. Here we can enter the item (text value, number, or cell reference) which we want to join. text2: Here we can enter the second item to…

5.0 15 VLOOKUP in MS Excel: VLOOKUP in MS excel is an important time saving function, which is helpful to every SAP Functional Consultant in various ways. Many times functional consultants come across situations where they have to search data in a certain column in ms excel sheet and match the data with another data base. Data set could be master data such as material master, customer master or transaction data such as Purchase Order,…