How to use "LEFT" Function in Excel

This function displays a specified number of characters from the left hand side of a given word.

Syntax:
=LEFT(OriginalText,NumberOfCharactersRequired)

Example:

Here is the video tutorial of the same for clear understanding.

Back to MS Excel>>