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".
MID, RIGHT.