RIGHT + FIND Function in Excel: Syntax, Examples and Free Practice
RIGHT + FIND is an Excel Text function. Uses FIND and LEN together to grab everything AFTER a delimiter like a space.
RIGHT + FIND syntax
Arguments
text: Full text to extract from" ": The character to search for as a cutoff point
When to use RIGHT + FIND
Pulling just someone's last name out of a 'First Last' full-name column.
Practice RIGHT + FIND online, free
Open the live Excel-style spreadsheet and try RIGHT + FIND yourself. No Excel install or sign-up needed to start.
Practice RIGHT + FIND now →More Text functions
Frequently asked questions
What does the RIGHT + FIND function do in Excel?
Uses FIND and LEN together to grab everything AFTER a delimiter like a space.
What is the syntax of RIGHT + FIND in Excel?
The syntax is =RIGHT(text, LEN(text)-FIND(" ", text)). text: Full text to extract from; " ": The character to search for as a cutoff point.
Where can I practice RIGHT + FIND online for free?
Open the free live spreadsheet on Cellgrids and try RIGHT + FIND yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts