RIGHTB function

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 as RIGHT if the input string has only single byte characters
• num_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)	熊本

Related functions

• MIDB :The MIDB function returns a section of a string starting at a given character and up to a specified number of bytes.
• LEFTB : The LEFTB function returns the left portion of a string up to a certain number of bytes.
• LENB : The LENB function returns the length of a string in bytes.