Excel Tips, Tricks, and Shortcuts

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) 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 w...