MID Function

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
FormulaDescriptionResult
=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.

Ask the Community

Was this article helpful?
YesNo