ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us
How to Use Excel > Excel Functions > Excel FIND Function

Excel FIND Function

How to Use the Excel FIND Function
Table of contents :
  • What is the Excel FIND Function?
  • FIND Syntax
  • How to Use FIND Function in Excel
  • FIND Example

Excel FIND Function

What is the Excel FIND Function?

The excel FIND function is looking for a text in another text. The FIND function has NO OPTION for wild card usage and does a case sensitive search.

FIND Syntax

FIND(find_text,within_text,[start_num])

find_text, required, text that you want to find.

within_text, required, text in which you want to find the find_text.

start_num, optional, starting position to find the find_text, the default is 1.

How to Use FIND Function in Excel

The following are examples of the FIND function usage and the results.

Excel FIND Function

FIND Function #1

=FIND(A2,B2)

You can ignore the start_num argument, by default it will be 1. The result is 6, the position of “soft” text in the “Microsoft Excel” text.

FIND Function #2

=FIND(A3,B3,C3)

Why is the result not the same as FIND Function #1? Isn’t the “SOFT” text in the “Microsoft Excel” text?

The FIND function looking for in case sensitive way, in the “Microsoft Excel” text there is a “soft” text instead of a “SOFT” text.

To do a case-insensitive search, use the SEARCH function.

  • How to Use the SEARCH Function in Excel

FIND Function #3

=FIND(A4,B4,C4)

The result is #VALUE! error, because excel FIND function has no option for the wildcard. To search using wildcard option use the excel SEARCH function.

FIND Function #4

=FIND(A5,B5,C5)

Why is the result 14? Isn’t there “E” letter at position 11?

The FIND function searches in a case sensitive manner, so the “E” and “e” letter are two different things.

FIND Function #5

=FIND(A6,B6,C6)

The FIND function returns a #VALUE! error if the start_num argument contains a zero or a negative number.

FIND Function #6

=FIND(A7,B7,C7)

The result is #VALUE! error. No number greater than the length of the text. Use excel LEN function to determine how long is the text,

FIND Example

Another article using or explain about FIND Function
  • Add and Remove Leading Zeros in Excel

Another Text Function

Another article about Text Function
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
Usefull links
  • Microsoft FIND, FINDB function documentation
Share
Tweet
Google+
Email
Prev Article
Next Article

Related Articles

Excel SEARCH Function
What is the Excel SEARCH Function? The excel SEARCH function …

Excel SEARCH Function

excel datedif function
What is the DATEDIF function? The Excel DATEDIF function calculates …

Excel DATEDIF Function

Excel INDEX Function
What is the Excel INDEX Function? The Excel INDEX function …

Excel INDEX Function

Excel PRODUCT Function
What is the Excel PRODUCT Function? What does product mean …

Excel PRODUCT Function

Excel NUMBERVALUE Function
What is the Excel NUMBERVALUE Function? Excel NUMBERVALUE function converts …

Excel NUMBERVALUE Function

Tags:Excel Function to Find Text in a Range Find and Replace Function in Excel Function Find in Excel How to Find Function in Excel How to Use Excel Find Function How to Use Find Function in Excel Text Functions Using the Find Function in Excel

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • Get the Original Price from Percentage Increase/Decrease
  • How to Add/Subtract Percentage in Excel
  • How to Extract Day, Month and Year from Date in Excel
  • How to Add Seconds, Minutes and Hours to a Time in Excel
  • How to Add Days, Weeks, Months and Years to a Date in Excel
  • How to Calculate Time Difference in Excel
  • Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel
  • Flash Fill Excel
  • Paste Special Excel
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
  • Excel LEFT Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2021 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh