Reference
No results for 'undefined'
    Powered by Algolia

    LEFT

    Returns the first character or characters in a text string, based on the number of characters you specify

    Syntax

    =LEFT(text, [numOfChars])

    Parameters

    1. text
      • Type: String
      • Description: Text get characters from
    2. numOfChars [optional]
      • Type: Integer
      • Description: Number of characters to get

    Returns

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

    Example

    =LEFT("text",2)

    See Also

    Contents