RIGHT Formula — Extract Last Characters from Text in Excel & Sheets (Free Tool)

Returns the last character or characters in a text string, based on the number of characters you specify.

Generated Formula
=RIGHT(text, 1)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

Common Errors & Fixes

  • RIGHT returns wrong characters

    Causes:
    • Incorrect num_chars value — counting from the end is counterintuitive.
    • Trailing spaces in the text are included in the count.
    Fixes:
    • Use LEN to verify text length first.
    • Use TRIM to remove trailing spaces before applying RIGHT.

Frequently Asked Questions

How do I use RIGHT to extract text after a specific character?

Combine RIGHT with FIND: =RIGHT(A1, LEN(A1) - FIND("@", A1)) extracts everything after the @ symbol in an email.

What happens if num_chars is negative?

RIGHT returns a #VALUE! error if num_chars is negative. Always use a positive number.

Does RIGHT work in Google Sheets?

Yes, RIGHT works identically in Google Sheets with the same syntax.

Related Formulas

Explore related formula generators to solve similar problems

CONCATENATETRIMUPPERLOWERPROPER

🛠️ Related Tools

Formula Comparator

Compare Excel formulas side by side

Remove Duplicates

Clean duplicate values from your data

GPA Calculator

Weighted & unweighted grade point average

SUMIFS Across Sheets

Sum across multiple Excel sheets

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More