Tag: ms excel tips for sap consultant

Concatenate function in MS Excel

 394 Total views

 394 Total views 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…

Read More »

VLOOKUP in MS excel

 663 Total views

 663 Total views 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…

Read More »

TRIM function in MS Excel

 411 Total views

 411 Total views While working in SAP, many times I came across situation where I got a list of material master with more than 50000 records and I had to find out and remove unwanted space at the end or starting of the text. I always used the TRIM function to…

Read More »