Extract a substring from a string, starting from the left-most character.
Syntax Left(string, NumberOfCharacters) Key string A string or string expression. NumberOfCharacters The Number of characters to return
The Left() function can be used in VBA or in an SQL query.
Dim strDemo as String
strDemo = Left("The world is everlasting", 9 )
Returns "The world"
“Begin at the beginning, the King said, very gravely, and go on till you come to the end: then stop” ~ Lewis Carroll
Mid - Extract a substring from a string
Right - Extract a substring from a string