LEFT

Examples

• =LEFT("January",3)

  The LEFT function returns "Jan" and this is because the function is only returning the first three characters of the string "January".

• =LEFT("ABC")

  The LEFT function returns "A" and this is because the function is only returning the first character of the string "ABC".

• =LEFT("apple",100)

  This LEFT function returns "apple"

• =LEFT(1000,3)

  The LEFT function returns "100"Tlike above this is because the function is returning the first three characters of the numeric value 1000. These characters are "100".

• =LEFT(text,FIND("@",text)-1)

  The LEFT function can be used with the FIND function to split a string at a specific character and will return everything to the left of the "@" symbol in a string: