Excel Function

LEFT

Returns leftmost characters from text.

LEFT(text, [num_chars])

Arguments

text

Required

Enter a text value (wrap with quotes when needed).

num_chars

Optional

Enter a numeric value.

Practice Preview

format and display text values. Use LEFT to Returns leftmost characters from text. use B2 for text, use 3 for num_chars. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=LEFT(B2, 3)

Practice This Function

Practice in Sequential Mode Back to Function List