Hello! Excel beginners, are you curious about the MID function? The MID function is useful for extracting a part of a string in Excel. In this guide, I will show you how to use the MID function and provide various examples to help you easily learn.
What is the MID function?
The MID function extracts a specified number of characters from a text, starting from a specific position. It is commonly used when dealing with text data and allows you to extract specific portions for various analyses.
How to Use the MID function
To use the MID function, you need to specify three arguments: MID(text, start position, number of characters to extract). Each role is as follows:
| Argument | Description |
|---|---|
| Text | The text from which you want to extract a part |
| Start Position | The index number where extraction should begin |
| Number of Characters to Extract | The number of characters to extract |
Examples of Using the MID function
1. Extracting Specific Characters from a Name
For example, to extract the last name from the name “홍길동” (Hong Gil-dong), you can use the MID function as follows:
=MID(“홍길동”, 1, 1)
The above MID function extracts one character from the beginning of “홍길동,” resulting in “홍.”
2. Extracting a Specific Part from a Phone Number
Let’s extract the middle numbers from the phone number “010-1234-5678.”
=MID(“010-1234-5678”, 5, 4)
This function extracts four characters starting from the fifth position in the phone number, resulting in “1234.”
3. Extracting the Month from Date Data
Extract the month from the date data, “2023년 12월 25일” (December 25, 2023).
=MID(“2023년 12월 25일”, 6, 2)
This function extracts two characters starting from the sixth position in the date, resulting in “12.”
Conclusion
By utilizing the MID function, you can handle text data more easily and efficiently. Flexibly apply the MID function in various situations to extract the information you need. If you want to learn more Excel functions, open Excel now and practice. I will continue to provide you with various Excel tips and features. Thank you!