5 must-know text functions you should know in excel

5 must-know text functions

Excel text functions are very useful in cleaning the data, extracting a part of data, joining the data, or searching the position of a word. Few are easy to use but some need the practice to use correctly. In this article, let’s learn 5 must-know text functions to elevate our proficiency in excel.

The formula that we will be learning is LEFT , RIGHT , MID , LEN and FIND.

LEFT function used in extracting some part from the left side of a text string. The syntax for LEFT function is as follow.

5 must-know text functions in excel
5 must-know text functions in excel

Here text is the text string from where we wanted to extract text and [num_chars] is … Continue Reading