Skip to main content

LEFT

The LEFT function returns a specified number of characters from the start of a text string.

Syntax​

=LEFT(text, [num_chars])

Parameters​

  • text: The text string to extract characters from
  • num_chars: Optional. The number of characters to extract (default is 1)

Examples​

=LEFT("Hello World", 5) // Returns "Hello"
=LEFT("Excel", 2) // Returns "Ex"
=LEFT("A") // Returns "A" (default 1 character)