It can be used as a worksheet function WS and a VBA function VBA in Excel. Generally it is used by combining it with other functions such as VALUE SUM COUNT DATE DAY etc. The RIGHT function can be useful if we wish to extract characters from the right side of a text string.
Use excel RIGHT as an argument under VALUE function.
To force a Right formula to output a number use it in combination with the VALUE function as demonstrated in this example. It will take that formula as an argument because the RIGHT formula is for text manipulation and VALUE function can be used to convert a text value into a numerical value. You can see in the figure above in row 3 that the formula RIGHT A32 returns the substring el since it is the last two characters of the string excel found in cell A3. Press Enter to complete the formula.