cansevin

<div>
If you are searching for the keyword Cash in a single cell, the formula suggested by Brian would return the desired output.<br />
<br />
But if the Cash keyword is anywhere in column A, try this...<br />
<br />

<pre><code id="code-20-42972474-1">=IF(COUNTIF(A:A,&quot;*cash*&quot;),&quot;Cash&quot;,&quot;Not Cash&quot;)</code></pre>
</div>


If you are searching for the keyword Cash in a single cell, the formula suggested by Brian would return the desired output.

But if the Cash keyword is anywhere in column A, try this...



=IF(COUNTIF(A:A,"*cash*"),"Cash","Not Cash")

<div>
<div class="content wysiwyg-content">
Column A has random text information in it. In Column B - I would like it to say &quot;Cash&quot; if the word &quot;Cash&quot; is included in Column A. If not, it says &quot;Not Cash&quot;.
</div>
</div>


Column A has random text information in it. In Column B - I would like it to say "Cash" if the word "Cash" is included in Column A. If not, it says "Not Cash".

Does the cell say &quot;Cash&quot; somewhere?

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Does the cell say &quot;Cash&quot; somewhere?

Does the cell say "Cash" somewhere?