Thursday, December 29, 2011

How To Extract Characters From Text String by Using LEFT Formula?

LEFT is one of the Most Useful Text Formula in MS Excel. LEFT returns the first character or characters in a text string, based on the number of characters you specify.

The Sytax for the LEFT function is

Here 'text' is nothing but the text word or words that contains the characters you want to extract and 'num_chars' specifies the number of characters you want to extract from the LEFT side of the text.


It results OB since OB is the first two characters extract from LEFT, in the given text.

If we want to extract first 3 Characters then the Formula should be =LEFT("OBAMA",3) and it results OBA

In the above example we entered the Text directly into the Formula. Instead of entering directly Text into the Formula we can use Cell Reference also.

Let say OBAMA text string is there in A1 cell in the Excel.
And we want to extract first four characters of OBAMA in A2 Cell.
Then we should enter the formula in A2 Cell by giving Cell Reference to A1

Then Formula in A2 Cell is =LEFT(A1,4) and it results OBAM

Points To Be Remember
  • 'num_chars' must be greater than or equal to zero
  • If num_chars is greater than the length of text then it results all of the text
  • If you don't put anything as num_chars, then simply it will result the first character of the text
  • Space in the text is also counts as one character
Now you can try your own with more exercises.

If you have any questions about LEFT formula, please share the same as comment.

How To Extract Characters From Text String by Using RIGHT Formula?


  1. It would be a great to share a bit more on this matter. I’m glad I come across your site really informative post. Thanks for sharing this material.

  2. It is great to have the opportunity to read a good quality article with useful information on topics that plenty are interested on.


  3. you've gotten an amazing blog here! would you prefer to make some invite posts on my weblog? online casino gambling


Share your comment here..