Returns a portion of text based on a given starting point and number of characters
Sample Usage
MID("Hello World!", 2, 5)
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
Examples
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.