LEFT function extracts a specified number of characters from the start of a text value.
|text||Text||Yes||The input text|
|number_of_characters||Numeric||Yes||The number of characters to include|
text argument is blank, or
number_of_characters is zero, then the result is will be a blank text value.
Note that while the name of the function, "LEFT", is inherited from Excel, it always refers to the beginning of the text, regardless of the writing direction. For Right-to-left languages, the LEFT function extracts the given number of characters from the start of the text, which would actually be the right-most characters visually speaking.
For example, the formula
LEFT("سلام الکس", 4) is equal to
In some cases, you might have a registration number, phone number, or other text that contains information embedded in the code. For example, in Holland, the first two digits of fixed-line phone numbers indicate the city. Numbers starting with "070" like 070 353 3000 belong to the City of the Hague, while those starting with "020" such as 020 334 4522 are in Amsterdam.
You can find the first three digits of a
PHONE_NUBMER text field using the formula:
You can then use the
IF function to compute the city based on these first three digits:
IF(LEFT(PHONE_NUMBER, 3) == "070", "The Hague", IF(LEFT(PHONE_NUMBER, 3) == "020", "Amsterdam", "Other"))