<div>
Thanks guys, &nbsp;both work. Almost a dead heat again :)
</div>


<div>
You're welcome. Glad we could help. :)
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I would like a formula that would determine if a cell contains specific text,<br />
example<br />
cell A2 contains &nbsp; &nbsp; Babyface (NR)<br />
If the cell contains (NR) as part of the text I want to return blank cell in B2<br />
Help much appreciated as always<br />
Many thanks<br />
Ian
</div>
</div>


Hi,
I would like a formula that would determine if a cell contains specific text,
example
cell A2 contains     Babyface (NR)
If the cell contains (NR) as part of the text I want to return blank cell in B2
Help much appreciated as always
Many thanks
Ian

Thanks guys,  both work. Almost a dead heat again :)

You&#39;re welcome. Glad we could help. :)

check if cell contains specific text

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