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

N

Niek Otten

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?
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top