LEFT Function or LEFT Formula in Excel with example

LEFT Function or LEFT Formula in Excel with example


In excel left function gives a very good example which helps user to extract desired number of characters from starting of input string using Left Function. Left function takes two arguments where second argument is option.


=LEFT(text, [num_chars])


  1. text: a mandatory parameter refers to a string from which characters need to be extracted.
  2. num_chars: its an optional parameter refers to a positive integer, refers to number of characters need to be extracted from given text, if omitted, first character of the string would be returned

Formula example



If you notice the first formula where I tried passing a negative number in the second parameter and got #VALUE! error, proving that we have to supply a positive number. The second formula governs that if we remove the second parameter LEFT function returns 1 character from the left of given string. Finally third formula shows that we want to extract 3 characters from the left of given string and resulting “VBA“.

Next >> TRIM Function in Excel with example

Leave a Reply

Your email address will not be published. Required fields are marked *