Excel FunctionsLesson 96Free preview
MID
This lesson is part of Excel · All levels
Summary
MID is an Excel text function that takes a number of characters from the middle of a text. The syntax is three-word. This function is useful for extracting code or specific parts of the combined data.
Key points
- Syntax: MID(text, start_num, num_chars) with three arguments
- Start_num is the position of the first character taken, counted from left
- If the start_num exceeds the length of the text, the result is empty text.
- Combined with FIND or SEARCH for dynamic position
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.