Formulas Excel Left

Formula

Description

=LEFT(text,num_chars)

Extracts a specified number of characters from the beginning of a text string.

=LEFTB(text,num_chars)

Extracts a specified number of bytes from the beginning of a text string.

=LEFTC(text,num_chars)

Extracts a specified number of characters from the beginning of a text string, taking into account double-byte characters.

=LEFTPAD(text,length,character)

Pads a text string with a specified character to a specified length by adding characters to the beginning.

=LEFTTRIM(text)

Removes any leading spaces or other specified characters from a text string.

=LEFTWORDS(text,num_words)

Extracts a specified number of words from the beginning of a text string.

Veja também mais Fórmulas com a letra F

Fórmulas que começam com:

Comentários