Returns a portion of text based on a given starting point and number of characters
Syntax
MID(text, start_position, num_chars)
- text—The text that you want to return a portion from
- start_position—Starting from the left, the number of the character you want to return
- num_chars—Starting from the left and depending on the start_position, the total number of characters to extract
Sample usage
MID("Hello World!", 2, 5)
Examples
| Formula | Description | Result |
|---|---|---|
| =MID("Hello World!", 2, 5) | Extracts 5 characters from "Hello World!" starting from the second character. | "ello " |
| =MID("Data Science", 6, 7) | Extracts 7 characters starting from the sixth character of "Data Science". | "Science" |
| =MID("1234567890", 4, 3) | Extracts 3 characters from "1234567890" starting from the fourth character. | "456" |
Still need help?
Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.