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 things done in Excel. In this accelerated 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. Instant access. See details here.