LEFT + FIND Function in Excel: Syntax, Examples and Free Practice
LEFT + FIND is an Excel Text function. Uses FIND to locate a delimiter (like a space), then LEFT to grab everything before it.
LEFT + FIND syntax
Arguments
text: Full text to extract from" ": The character to search for as a cutoff point
When to use LEFT + FIND
Pulling just someone's first name out of a 'First Last' full-name column.
Practice LEFT + FIND online, free
Open the live Excel-style spreadsheet and try LEFT + FIND yourself. No Excel install or sign-up needed to start.
Practice LEFT + FIND now →More Text functions
Frequently asked questions
What does the LEFT + FIND function do in Excel?
Uses FIND to locate a delimiter (like a space), then LEFT to grab everything before it.
What is the syntax of LEFT + FIND in Excel?
The syntax is =LEFT(text, FIND(" ", text)-1). text: Full text to extract from; " ": The character to search for as a cutoff point.
Where can I practice LEFT + FIND online for free?
Open the free live spreadsheet on Cellgrids and try LEFT + 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