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
 =LEFT(text,[num_chars])



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.


 =LEFT("OBAMA",2)



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


Exercise
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?

2 comments:

  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.

    www.n8fan.net

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

    Count
    www.imarksweb.org

    ReplyDelete

Share your comment here..