Functions
LEFT
Left portion of a string
Try it
When to use it
When should I use LEFT instead of MID?
Use LEFT when you want characters starting from the beginning of the text. Use MID when the slice you want starts somewhere in the middle.
How do I get the part of a code before a separator?
Combine LEFT with FIND to grab everything up to a character, or pass a fixed length to LEFT when the prefix is always the same size.
Use cases
Pull the first three letters of a name
Extract a leading area code
Used in
operations · retail · sales
Syntax
LEFT(text, num_chars)