RIGHTB
The RIGHTB function returns a specific number of characters from the end of a string, based on the given amount of bytes.
This function can be useful when working with double-byte characters, such as hieroglyphs or special characters that are larger than one byte.
Syntax
RIGHTB(string, [num_bytes])
| Argument | Description | Permitted values |
|---|---|---|
| string | String from which the right fragment is returned | Text string or reference to a cell containing text |
| [num_bytes] | (optional) The number of bytes that need to be returned from the right side of the “string” argument. By default, 1 | Integer ≥1 or a reference to a cell containing a number |
Examples of use
RetrievIng bytes from a string
If cell A1 contains the text “Hello” and you want to retrieve the last 3 bytes:
=RIGHTB(A1, 3)
The expression will return “llo” as these are the last 3 bytes of the text.
Retrieving a single byte
If you want to retrieve the last byte from the string:
=RIGHTB(A1)
The expression will return “o”, since this is the last byte of the string.
Notes
- The RIGHTB function is useful for working with texts in languages that use double-byte characters, as it takes into account the byte length of characters.
- If the num_bytes exceeds argument the length of the string, the function will return the entire string.