In this tutorial, you will know the method of extracting the specified characters from the end of the text string in your Excel spreadsheet.
Syntax
RIGHT(text,num_chars)
Syntax
RIGHT(text,num_chars)
- RIGHT returns the first character or characters in a text string, based on the number of characters you specify.
- RIGHT always counts each character, whether single-byte or double-byte, as 1 (one), it does not matter what the setting of the default language as is.
- TEXT is the text string that contains the characters you want to extract. Whatever text string consists of single-byte or double-byte characters, the following formula represents each one as only 1 string abstract.
- Num_chars specifies the number of right characters that you would like to extract.
- Num_chars must be greater than or equal to zero. If it is less than zero, the result will display “#VALUE!” that means it comes out with nothing.
- If num_chars is greater than the length of text, Right returns all of text.
- The result will return with 1 (One), If num_chars is omitted.
Method of using formula:
In cell A2: Fill out the data [I want to extract BIRD]
In cell B2: Type this formula into it [=RIGHT(A2,4)]
You should have the text "BIRD" remaining in your cell "B2"
Do you find this article useful?
See more another tips:
Michael Leng is Thai, has a BA in Hotel management from Ramkhamhaeng University. He had worked for some hotels. Currently he works in logistics field, Bangkok, Thailand. Because of loving in English, he has written some his own blogs in English-he really wants any feedback about his English he has posted.
See more another tips:
- How To Extract The Specified Characters From The Left Of The Text String In Active Cell
- Delete Unwanted Characters and or Blank Space From The Left Side Of Contents In Active Cell
- Removes Characters and Blank Space From The Right Side Of Contents In Cell | Xcel-Guru
- Excel Trick Expand Excel Column Width Fit To The Longest Data Entered
- [Ctrl] + [-](minus sign) Excel Shortcut Open Dialog Box Menu of Delete Cells, Row and Column Function
- 4 Cool Ways To “Sum” Values Of Number In An Excel Worksheet – ExcelTip2day
- How To Use AVERAGEIF Formula "Not" Including “0” (Zero) In Range
- [Shift + Space Bar] Excel Tip How To Select The Entire Row of Excel Worksheet
- Function [Home] Excel Keyboard Key | X'cel
- [Page Down] Microsoft Excel Keyboard Shortcut Button And Method
- Turn Off / Turn On Scroll Lock Excel Tip To Lock & Unlock On Keyboard
- Monitor Screen Accidentally Upside Down Problem Solving Medthods And Tricks
- How to calculate amount of the current column in excel?
- How to combine words in different cells into one cell
- Shortcut Trick and Tip for Microsoft Excel Office Software Program
- Fill Out Respective Data 2 Cells Intervening by Non-Adjacent Cells Each
- Learn Thai Free Online [LTFO] | Michael Leng
- Just Sing Along Blog | Song Lyrics In English-Thai Language
- Book-Hub | Best Seller Book Review
- [C+] Cell Phone and Accessory Review
- [1English-1Thai] English – Thai Dictionary Learning Blog
Comments
Post a Comment