Posted on Leave a comment

LEFT , RIGHT , MID , Functions in Excel

LEFT, RIGHT and MID functions extract a substring from a string. We can specify how many characters to be extracted. This functions are categorized as a String/Text Function.

In this video we described how to use LEFT , RIGHT and MID functions in different situations.

 

 

Posted on Leave a comment

SEARCH , FIND Function in Excel

The Microsoft Excel SEARCH and FIND functions returns the location of a substring in a string. The only difference between these two functions is that FIND is case-sensitive, but SEARCH is NOT. SEARCH and FIND functions are built-in functions in Excel that are categorized as String/Text Functions.
In this video we describe these functions in details and explain the difference between them with examples. For more videos like this, please subscribe us.

Posted on Leave a comment

CONCAT and CONCATENATE Function in Excel

The Microsoft Excel CONCAT function allows you to join 2 or more strings together. It was released in Excel 2016 and replaces the CONCATENATE function. The CONCAT function is categorized as a String/Text Function.
In this video we describe how to use this function in different situations.

Posted on Leave a comment

Function definition in Excel

In this video we define the concepts of Excel functions and the way of writing functions in Excel. Functions, which we can call them formulas in Excel are predefined algorithms in Excel software that allow us do some manipulation and operations on data (or cells value or range of cells)