Though it performs the same operation on digits as it does with text, it returns wrong values with numbers formatted as text. Note: The RIGHT function should not be used with numbers. Sometimes, it is difficult to identify the kind of mistake behind this error.

If “num_chars” is less than zero, the RIGHT function returns the “ #VALUE! error #VALUE! Error #VALUE! Error in Excel represents that the reference cell the user has either entered an incorrect formula or used a wrong data type (mostly numerical data).If “num_chars” is greater than the length of the text, the RIGHT function returns the complete text.This means that if the value of “num_chars” is omitted, the RIGHT function returns the last letter of the string.

The default value of “num_chars” is set at 1.The features of “num_chars” are listed as follows: The “text” is a mandatory argument and “num_chars” is an optional argument. Num_chars: The number of characters to be extracted from the string starting from the rightmost side.Text: The text string that contains the characters to be extracted.The RIGHT function accepts the following two arguments: You are free to use this image on your website, templates, etc., Please provide us with an attribution link How to Provide Attribution? Article Link to be Hyperlinked The syntax of the RIGHT function is stated as follows:

Right justify text excel