You are having a headache because you don’t know what the function to get the string in Excel is? Let’s Taimienphi.vn learn about the function to get the string in Excel through the following article.
There are 3 functions used to get a string that can answer the question “What is the function to get the string in Excel?”. The MID function, along with LEFT and RIGHT, are functions that take characters from a string in Excel. If the Left function is the function that takes the left string, the Right function is the function that takes the right string, the Mid function is the function that takes the middle string corresponding to the value we require for it. We will learn about the syntax and usage of the Mid function in the article below.
INSTRUCTIONS FOR USING MID MIDDLE WITH A CHARACTER IN EXCEL
The function of the MID function is to cut out n characters in the string from the original position m
The syntax of the MID function is as follows: = MID (text, m, n)
Inside: – text: character string to cut
– m: The start position of the string
– n: The number of characters to cut from the string
Take an example like this:
We have a student list data table and require filtering out the industry code from the student’s class name. Corresponding is 2 characters starting from the 4th character in the class name.
Step 1: Enter the formula in the cell E7: = MID (D7,4,2) then press Enter. Get the 2 characters starting from the 4th character in cell E7
Step 2: The results appear as shown below. Pull down so the remaining cells do the same
In addition to the MID function, the LEFT and RIGHT functions are also two functions that take characters from left and right respectively in the string.
– LEFT function: = LEFT (text, n)
– RIGHT function: = RIGHT (text, n)
Inside: – text is the string to retrieve
– n is the number of characters to cut. Without the n parameter, Excel automatically retrieves it from the first value in the string
Above is instructions for using string functions in Excel. Now you know what the function is to get a string in Excel. To improve your Excel knowledge, you should learn some other functions such as SUMIF function in Excel to sum conditionally in reverse or SUM function to help sum up vertically easily and countless Excel functions. Other are mentioned Taimienphi.vn, detailed instructions. If in the process of implementation you encounter difficulties, do not be afraid to comment below, Taimienphi.vn technical team will support you.