RIGHT () and RIGHTB () Functions in Excel

This article provides a clear overview of RIGHT () and RIGHTB () Functions in Excel, with the main facts, useful context, and practical details organized for easy reading.

There are many people who do not know how to use the RIGHT () and RIGHTB () functions. You follow the article below to know how to use these two functions.

Description

The RIGHT () function returns the result as one or more final characters in a text string based on the number of characters you give. The RIGHT () function always comes with every 1 character whether it is single byte or double byte or whatever the default language is.

The RIGHTB () function returns the result as one or more end characters in the text string based on the number of bytes you specify. The RIGHTB () function counts each double-byte character as 2 if the language is set by default as one of the languages that support DBCS, otherwise the function will count each character as 1.

Syntax

= RIGHT (text, [num_chars])

= RIGHTB (text, [num_bytes])

Arguments

- text: is the text string you may need to extract the characters.

- num_chars: the number of characters you want the RIGHT () function to extract.

- num_bytes: the number of bytes you want the RIGHTB () function to extract.

Note

- If num_chars is omitted, its default is 1.

- Num_chars must always be greater than or equal to 0.

- If num_chars is greater than the length of the text string, the function will return the entire text string.

For Example

For a text string "Nguyen Van Binh" you extracted the last 5 characters from the text.

- Enter text directly into the RIGHT () function.

- Refer text from a cell in Excel to the RIGHT () function.