Loading...

RIGHT – Excel Function | Blake Ekelund

RIGHT

Extract characters from the end (right side) of text.

Beginner

— views

Syntax

=RIGHT(text, [num_chars])

Example Use Cases

Extract last 3 letters of a code
Get file extension
Pull last digit of an ID

Common Issues

Using RIGHT on numeric values without converting them to text first
Expecting RIGHT to remove prefixes instead of suffixes
Getting #VALUE! when num_chars is negative or non-numeric

Pro Tips

Combine RIGHT with LEN to remove fixed prefixes
Use RIGHT to isolate file extensions or version tags
Pair RIGHT with FIND to extract text after a symbol

Related Functions in TEXT & FORMATTING

Beginner Functions

Function	Use Case	Syntax
LEN	Count the number of characters in a text string.	=LEN(text)
CLEAN	Remove non-printable characters from imported or messy text.	=CLEAN(text)

Intermediate Functions

Function	Use Case	Syntax
TEXT	Format numbers, dates, or times as text using custom formatting.	=TEXT(value, format_text)
FIND	Locate the position of a character or substring in text.	=FIND(find_text, within_text, [start_num])