<div>
=COUNT(SEARCH({&quot;Office&quot;,&quot;E<wbr />xcel&quot;,&quot;Acc<wbr />ess&quot;},A1))<wbr />&gt;0<br />
<br />
for example.
</div>


=COUNT(SEARCH({"Office","Excel","Access"},A1))>0

for example.

<div>
When I paste this exact formula in excel I get a message that it contains an error.
</div>


When I paste this exact formula in excel I get a message that it contains an error.

<div>
<div class="content wysiwyg-content">
I want to search wether a cell contains either &quot;office&quot; or &quot;excel&quot; or &quot;access&quot;.<br />
The formula should also give a succes when multiple of the strings are present in the cell.
</div>
</div>


I want to search wether a cell contains either "office" or "excel" or "access".
The formula should also give a succes when multiple of the strings are present in the cell.

I need a formula that I can search for the existance of one of multiple strings in a cell

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.