What's the difference between FIND() and SEARCH()?

  • Thread starter Thread starter Schizoid Man
  • Start date Start date
S

Schizoid Man

They both appear to do exactly the same thing. Am I missing something here?
 
I think the main difference is Find is case-sensitive and Search isn't.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| They both appear to do exactly the same thing. Am I missing something here?
 
from Help:

You can also use SEARCH to find one text string within another, but unlike
SEARCH, FIND is case-sensitive and doesn't allow wildcard characters.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Differences Between Two Spreadsheets ? 1
File Download - Security Warning 5
Thoughts on Apple AirTags? 1
Windows 10 Windows 10 can't find scanner (part of an multi-function printer) 6
Searching specify data 1
Windows 7 Difference in "size on disc" between files and copied files - a problem? 3
Excel2007 | I want to create a pivotTable from a different data, and different sheets 0
Windows 10 operating system - using firefox browser - yahoo mail. 5

Back
Top