RIGHT Function
RIGHT function is used to retrieve characters from the right on a string. Formula / basis of formulas RIGHT function is ... ..
= RIGHT (String, X) / / = RIGHT (cell address, X) or
= RIGHT (String; X) / / = RIGHT (cell address; X)
Description:
String: words / strings, or cells that would have taken his character
X: Number of characters taken from the right.
For example:
= RIGHT ("Yogyakarta", 5) - Enter - result: karta
= RIGHT ("technology", 4) - Enter - result: logy
What if using a table in Excel as shown below:
RIGHT function is used to retrieve characters from the right on a string. Formula / basis of formulas RIGHT function is ... ..
= RIGHT (String, X) / / = RIGHT (cell address, X) or
= RIGHT (String; X) / / = RIGHT (cell address; X)
Description:
String: words / strings, or cells that would have taken his character
X: Number of characters taken from the right.
For example:
= RIGHT ("Yogyakarta", 5) - Enter - result: karta
= RIGHT ("technology", 4) - Enter - result: logy
What if using a table in Excel as shown below:
