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.
Here text is the text string from where we wanted to extract text and [num_chars] is … Continue Reading