Author: Oscar Cronquist Article last updated on April 18, 2018

The LEFT function extracts a specific number of characters always starting from the left.

Excel Function Syntax

LEFT(text, [num_chars])


text Text string or a cell reference to a text string.
[num_chars] The number of characters to extract. Optional. If this argument is not entered only the first character is extracted.