Blake Ekelund
Excel
FP&A
Web Dev
Blog
Off the clock
Search
Ctrl K
Say hi
→
Loading...
RIGHT – Excel Function | Blake Ekelund
Excel Library
›
RIGHT
RIGHT
Extract characters from the end (right side) of text.
Beginner
— views
All
Syntax
Tutorial
Examples
Common Issues
Pro Tips
Related
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])