Saturday, July 23, 2011

RIGHT Function In Ms. Excel

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:

0 comments:

Similar Post

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites