Left

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 may be used in VBA or in an SQL query.

Examples

Dim strDemo as String
strDemo = Left("The world is everlasting", 9 )
Msgbox strDemo
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

Related:

Mid - Extract a substring from a string
Right - Extract a substring from a string


© Copyright SS64.com 1999-2014
Some rights reserved