<div>
Try pattern:<br />

<pre><code id="code-20-42752250-1">btu(\/h)?</code></pre>
with the case insensitive option active.<br />
<br />
Demo:<br />
<a href="https://regex101.com/r/jddy9t/1" rel="ugc">https://regex101.com/r/jddy9t/1</a>
</div>


Try pattern:


btu(\/h)?

with the case insensitive option active.

Demo:
https://regex101.com/r/jddy9t/1 [https://regex101.com/r/jddy9t/1]

COG Lead Engineer

Shaun Vermaak

<div>
Or did you specifically want the given combinations of upper/lower case?
</div>


Or did you specifically want the given combinations of upper/lower case?

<div>
Yes, this needs to be case sensitive. &nbsp;Also, this did not work. &nbsp;I need an expression that would cover all the scenarios listed below.<br />
<br />
Value<br />
---------<br />
40005 Btu/h &nbsp; &nbsp;----&gt; &nbsp;I need to detect if the value has &quot;Btu/h&quot;<br />
5009 BTU/H &nbsp; &nbsp;----&gt; &nbsp;I need to detect if the value has &quot;BTU/H&quot;<br />
6999 BTU &nbsp; &nbsp; &nbsp; &nbsp;-----&gt; I also need to detect if value has just &quot;BTU&quot;. <br />
6700 <br />
900000 Btu
</div>


Yes, this needs to be case sensitive.  Also, this did not work.  I need an expression that would cover all the scenarios listed below.

Value
---------
40005 Btu/h    ---->  I need to detect if the value has "Btu/h"
5009 BTU/H    ---->  I need to detect if the value has "BTU/H"
6999 BTU        -----> I also need to detect if value has just "BTU".
6700
900000 Btu

tmajor99

Excel & VBA Expert

Subodh Tiwari (Neeraj)

<div>
<div class="content wysiwyg-content">
I need a regular expression to check for a word in a string that has a &quot;/&quot;. &nbsp;<br />
<br />
Value<br />
---------<br />
40005 Btu/h &nbsp; &nbsp;----&gt; &nbsp;I need to detect if the value has &quot;Btu/h&quot;<br />
5009 BTU/H &nbsp; &nbsp;----&gt; &nbsp;I need to detect if the value has &quot;BTU/H&quot;<br />
6999 BTU &nbsp; &nbsp; &nbsp; &nbsp;-----&gt; I also need to detect if value has just &quot;BTU&quot;. <br />
6700 <br />
900000 Btu
</div>
</div>


I need a regular expression to check for a word in a string that has a "/".  

Value
---------
40005 Btu/h    ---->  I need to detect if the value has "Btu/h"
5009 BTU/H    ---->  I need to detect if the value has "BTU/H"
6999 BTU        -----> I also need to detect if value has just "BTU". 
6700 
900000 Btu

Regular Expression - Check for word in a string

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.