The RIGHTB function returns the right portion of a string up to a certain number of bytes.
Parts of a RIGHTB function
RIGHTB(string, num_of_bytes)
Part | Description |
string |
The string from which the right portion will be returned. |
num_of_bytes |
(Optional) The number of bytes to return from the right side of `string`. |
Notes
RIGHTB
returns the same value asRIGHT
if the input string has only single byte charactersnum_of_bytes
must be greater than or equal to zero.- If
num_of_bytes
is greater than the length of text in bytes,RIGHTB
returns all of text. - If
num_of_bytes
is omitted, it is assumed to be 1.
Examples
A | B | C | |
1 | Input | Formula | Output |
2 | Aeñ | =RIGHTB(A2, 2) |
eñ |
3 | Aeñ | =RIGHT(A3,2) |
eñ |
4 | 熊本 |
=RIGHTB(A4, 2) |
本 |
5 | 熊本 |
=RIGHT(A5,2) |
熊本 |