MS Excel offers a variety of statistical functions. Source: Cheat Sheet of Excel Formulas () #2 Statistical Functions in Excel You are free to use this image on your website, templates etc, Please provide us with an attribution link How to Provide Attribution? Article Link to be Hyperlinked The above-explained cheat sheet of excel formulas examples is implemented in the excel worksheet shown in the following screenshot. Where D2 and F2 are the cells to be concatenated. Returns the number of characters in the given string Where B2 is the cell containing text, 1 is the starting position, and 4 is the number of chars to be retrieved. MID (string, starting_position, no_of_characters) Returns the specified number of characters from the string starting from the given position Returns the specified number of characters from the right of the string Where B2 is the cell containing the text. Returns the specified number of characters from the left of the string The table contains the name of the function, the meaning of the function, the syntax, and the example. Some Excel Formulas Cheat Sheet is given below.

MS Excel offers a variety of string functions. You can download this Cheat Sheet of Excel Formulas Template here – Cheat Sheet of Excel Formulas Template #1 Text Functions in Excel