LEFT(text, [num_chars])
=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:
The LEFT function allows you to extract text from the left side of a string and returns one or more characters.