Excel Function

RIGHT

Returns rightmost characters from text.

RIGHT(text, [num_chars])

Arguments

text

Required

Enter a text value (wrap with quotes when needed).

num_chars

Optional

Enter a numeric value.

Practice Preview

Use RIGHT to return the result with these settings (Text: B2 (cell B2 (Name in column B)), Number of characters: 3).

Example Table

#	AEmployee ID	BName	CEmail	DPayment Amount	EAmount Text
2	E001	Taro Tanaka	t.tanaka@example.com	1200	1200
3	E002	Hanako Suzuki	h.suzuki@example.com	980	980
4	E003	Ken Sato	k.sato@example.com	2450	2450
5	E004	Aya Takahashi	a.takahashi@example.com	3000	3000
6
7
8

How to Use (Formula)

=RIGHT(B2, 3)

Result

aka

Practice This Function

Start Function Practice Back to Function List

RIGHT FAQ

How do I use RIGHT in Excel?

Use RIGHT when you want to extract characters from the right side of text. Enter Text, Number of characters in that order, then add optional arguments when needed.

Where can I practice RIGHT?

Use the "Start Function Practice" button to jump straight into RIGHT drills.

What arguments does RIGHT use?

The main arguments are Text, Number of characters. Start with the required ones, then add optional arguments if needed.