Left Function in Excel | Advance Excel Course

The LEFT function in Excel is a text function that allows you to extract a specified number of characters from the left side of a text string. It can be used to manipulate text data in various ways, such as splitting names or addresses into separate fields or extracting specific parts of a text string.

=LEFT(text, [num_chars])

text -  text string from which you want to extract characters
num_chars - the number of characters you want to extract