<div>
Thank you very much.<br />
<br />
Conernesto
</div>


<div>
You may also try something like this...<br />
<br />

<pre><code id="code-20-42538775-1">=IF(COUNTIF(A1,&quot;*DORM*&quot;),&quot;DORM&quot;,&quot;&quot;)</code></pre>
</div>


You may also try something like this...



=IF(COUNTIF(A1,"*DORM*"),"DORM","")

<div>
<div class="content wysiwyg-content">
I have a column with various names on column A1. I want to put a formula on column B1 that looks at column A1 and if A1 has the words &quot;Dorm&quot; return the value &quot;Dorm&quot; else leave blank. Below is an example of what is con column A1 and A2. Do you have an Excel formula that can do this?<br />
<br />
8858T17 - 2017 <br />
8858DORM
</div>
</div>


I have a column with various names on column A1. I want to put a formula on column B1 that looks at column A1 and if A1 has the words "Dorm" return the value "Dorm" else leave blank. Below is an example of what is con column A1 and A2. Do you have an Excel formula that can do this?

8858T17 - 2017 
8858DORM

Excel Formula

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.