How To Use LEFT Function | Microsoft Excel

Left Function will return the specified character from the reference string from the left side.

Syntax of LEFT Function

=LEFT(text,[num_chars])

Arguments of LEFT Function

text: It is a string or text which you want to extract
num_char: how much character you want in return

Behavior of LEFT Function

You have a broad data and you just want to retrieve only some characters of the column at that time this function comes to action.

Here we have taken five names. And I want only 5 letters of names so here I have used a left function.

If you do not describe that how much characters you want in return LEFT function will return only first character of the string.

This function returns me first five characters of the names.

Usage of LEFT Function

To get a limited character from long strings(text)

Return of LEFT Function

LEFT will return a small part of the string from the left side of string(text)


How would you like this content to write us in the comment box!

If you face any difficulty in the content feel free to ask!

Thank You.