Basic Excel Functions you should know to make your work life easier
As an IT Professional you may have to deal with lots of data every day. I have seen many experienced IT admins spending quite lots of time on the activities which can be quickly performed in Excel if you know few basic Excel formulas. I will explain most commonly used Excel functions here. Let's start with the String Functions. String Functions: Microsoft Excel offers many functions to manipulate string data. 1. LEFT() LEFT Function allows you to extract the leftmost characters from a string. Syntax : =LEFT(Text,Num_Chars) The Text parameter refers to the string you want to manipulate The Num_Chars parameter refers to the number of characters from left side of string you want to extract. Example: In the below example, we have extracted first 4 characters from left. 2. RIGHT() RIGHT Function allows you to extract the rightmost characters from a string. Syntax : =RIGHT(Text,Num_Chars) The Text ...