Syntax

LEFT(some-text, how-many)

Arguments

  • some-text (any textual)
  • how-many (any numeric or textual) : The number of characters from some-text to return. A real number will be rounded to the nearest integer. A textual value is equivalent to 0.

Return Value

Text: The first how-many characters from some-text. If how-many is greater than the length of some-text or less than 0, some-text is returned in its entirety.

Examples

LEFT("123 Maple Dr", 5) : 123 M

LEFT("123 Maple Dr", 0) returns blank.

First & Last Initials

LEFT([First Name], 1) & LEFT([Last Name], 1), assuming [First Name] and [Last Name] evaluate to Martin and Sandwich, respectively: MS

  • LEFT(..., 1) gets the first character of the specified column value.
  • LEFT(...) & LEFT(...) concatenates the two initials into a single text value.

Equivalent to INITIALS(CONCATENATE([First Name], " ", [Last Name])).

See also: CONCATENATE(), INITIALS()

Street Number from Street Address

LEFT([Address], (FIND(" ", [Address]) - 1)), assuming [Address] evaluates to 123 Maple Dr: 123

  • FIND(" ", [Address]) locates the first/leftmost space in the Address column value: 4
  • FIND(...) - 1 locates the character immediately preceding the first space: 3
  • LEFT([Address], ...) returns the leftmost text preceding the first space: 123

Equivalent to INDEX(SPLIT([Address], " "), 1).

See also: FIND(), INDEX(), SPLIT()

See Also

INITIALS(), MID(), RIGHT()

Did this answer your question?