LEFT Function

Description

Extract the specified number of characters from the beginning of the specified field.

It takes two arguments.

  • Argument 1: Specify the original string.
    • You can use either a string or a number. Specifying other data types will result in an error.
  • Argument 2: Specify the number of characters.

Usage Examples

In the following example, the result is “🍵 or ☕”.

= left ("Which one do you want 🍵 or ☕?"), 3)

Restrictions

  • Internet Explorer 11 is not supported.

関連記事