Exceljet

Quick, clean, and to the point

Excel FIND Function

Excel FIND function
Summary 

The Excel FIND function returns the position (as a number) of one text string inside another. When the text is not found, FIND returns a #VALUE error.

Purpose 
Get the location of text in a string
Return value 
A number representing the location of find_text.
Syntax 
=FIND (find_text, within_text, [start_num])
Arguments 
  • find_text - The text to find.
  • within_text - The text to search within.
  • start_num - [optional] The starting position in the text to search. Optional, defaults to 1.
Usage notes 
  • The FIND function will return the location of the first instance of find_text in within_text.
  • The location is returned as the number of characters from the start of within_text.
  • Start_num is optional and defaults to 1.
  • FIND will return #VALUE if find_text is not found in within_text .
  • FIND is case-sensitive and does not support wildcards.
  • Use the SEARCH function to search without case-sensitivity and/or to use wildcards.

Excel Formula Training

Formulas are the key to getting work done in Excel. In this step-by-step training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Start building valuable skills with Excel formulas today. Learn more.

I love to use excel and use it a lot in my work. Your tips, tricks and examples have helped me enormously. - Lisa
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course