Sunday, January 8, 2012

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

RIGHT is one of the Most Useful Text Formula in MS Excel. RIGHT returns the Last Character or Characters in a Text String, based on the number of characters you specify.

The Syntax for the RIGHT 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 RIGHT side of the text.


It results AN since AN is the last two characters extract from RIGHT, in the given text.

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

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 SARAN text string is there in A1 cell in the Excel.
And we want to extract last four characters of SARAN in A2 Cell.
Then we should enter the formula in A2 Cell by giving Cell Reference to A1

Then Formula in A2 Cell is =RIGHT(A1,4) and it results ARAN


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 RIGHT formula, please share the same as comment.

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


  1. Thanks for sharing the info.I believe that you recognize how to construct people pay attention to what you have to pronounce, particularly with a concern that’s so vital. I am pleased to suggest this blog. Please visit our site @


  2. Love it! Very interesting topics, I hope the incoming comments and suggestion are equally positive. Thank you for sharing this information that is actually helpful.

  3. I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article.


Share your comment here..