LEFT

  • Updated

Returns the leftmost characters of a string.

Sample Usage

LEFT("spreadsheet",6)
LEFT(C5)

Syntax

LEFT(text, [number])

  • text - The string whose leftmost characters are returned. 
  • number - [OPTIONAL]The number of characters to return. 

 

Examples

LEFT("spreadsheet",6) returns six leftmost characters of the string - "spread".
LEFT(C5) returns the leftmost character of the string in C5.

Notes

  • If number is omitted, it is assumed to be 1.
  • number must be greater than or equal to zero.
  • If number is greater than the length of text, LEFT returns all of text .