RIGHT Function Syntax and Arguments
In Excel, the syntax of a function refers to the layout and order of the function and its arguments. Arguments are the values functions use to perform calculations. A function’s syntax includes the function’s name, parentheses, and arguments. The syntax for the RIGHT function is: =RIGHT(Text,Num_chars) The function’s arguments tell Excel what data to look at in the function and the length of the string it should extract. Text (required) is the desired data. Use a cell reference to point out the data in the worksheet, or use the actual text in quotation marks. Num_chars (optional) specifies the number of characters on the right of the string argument that the function should retain. This argument must be greater than or equal to zero. If you input a value that is greater than the length of the text, the function returns all of it.
Using the Function Dialog Box
To make things even simpler, select the function and arguments using the Function Dialog Box, which takes care of the syntax by entering the function’s name, commas, and brackets in the correct locations and quantity.
Removing Unwanted Text Characters
The example in the image below uses the RIGHT function to extract the term “Widget” from the longer text entry *&^%Widget located in cell B1 in the worksheet. The function in cell C1 looks like this: =RIGHT(B1,6)
