Microsoft® Excel® 2010 Formulas & Functions Inside Out

RIGHT(), RIGHTB()

Syntax

• RIGHT(text;num_chars)

• RIGHTB(text;num_bytes)

Definition. The RIGHT() function returns the last characters of a string. The RIGHTB() function is used for double-byte characters and returns the last bytes.

Arguments

• text (required). The string from which to extract the characters

• num_chars/num_bytes (optional). Specifies how many characters to extract

Background. Use the RIGHT() function to extract characters from the end of a string (see Figure 8-10). You can enter letters or numbers in the text argument. The functions RIGHT(), LEFT(), and MID() are especially useful for extracting information from strings with set formats, such as ZIP Codes, locations, or ISBNs.

Figure 8-10. Resolving text problems is not magic but is accomplished ...