Reference
No results for 'undefined'
    Powered by Algolia

    MID

    Returns a segment of a text string

    Syntax

    =MID(text, startingAt, extractLength)

    Parameters

    1. text
      • Type: String
      • Description: The text string to extract a segment from
    2. startingAt
      • Type: Integer
      • Description: The index from the left of text string from which to begin extracting. The first character in text string has the index 1
    3. extractLength
      • Type: Integer
      • Description: The length of the segment to extract. If the end of text string is reached before extractLength characters are encountered, MID returns the characters from startingAt to the end of text string

    Returns

    • Type: String
    • Description: Returns the last character or characters

    Example

    =MID("text",2,3)

    See Also

    Contents