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

  • Thread starter Thread starter Schizoid Man
  • Start date Start date
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
 
Back
Top