LEFTB(text, [num_chars])
The LEFTB function can be used to extract a specified number of characters from the left side of a text string. For example, =LEFTB("January",3) returns "Jan", as it extracts the first three letters from the left side of the string.
If only one argument is provided, the LEFTB function will return the first character of the text string. For example, =LEFTB("ABC") returns "A".
The LEFTB function can also be used with numbers. If a number is provided as the text string, the LEFTB function will return a text string with the number of characters specified by the second argument. For example, =LEFTB(1000,3) returns "100" as a text string.
The LEFTB function can be combined with other functions to return characters from the left side of the text string up to a specific character. For example, =LEFT(text,FIND(char,text)-1) returns the text to the left of the first occurrence of the char.
The LEFTB function in Sourcetable is used to extract a certain number of characters from the beginning of a string. It is useful for quickly retrieving specific information from a text.