LEFT

LEFT —

LEFT(text[,num_chars])

LEFT returns the leftmost num_chars characters or the left character if num_chars is not specified.

This function is Excel compatible.

LEFT("Directory",3) equals "Dir".