What is the difference between FIND and SEARCH text functions in Excel?

Microsoft Excel Medium

Microsoft Excel — Medium

What is the difference between FIND and SEARCH text functions in Excel?

Key points

  • FIND is case-sensitive; SEARCH is case-insensitive
  • FIND does not support wildcards; SEARCH supports wildcards (* and ?)
  • FIND returns the position number; SEARCH returns the text at the found position

Ready to go further?

Related questions