title: Extracting different specified words from a particular string
body: <p>I have a column in my excel which i want to modify.
  Ill be needing the following</p>
  <p>If a particular column has words like &quot;CAP&quot;,&quot;Caps&quot;,&quot;caps&quot;,&quot;Cap&quot;,&quot;cap&quot;,&quot;CAPS&quot; then an empty column should say &quot;caps&quot; or else &quot;Default&quot;.</p>
  <p>For Example:</p>
  <p>Description                             Type
  Cap for DPRD                            caps
  Pickup cap change GLS criticality&gt;  caps
  Raise Caps for CGN9                 caps
  Place TT Pads on DHL Lanes          Default
  Noncon Caps for MXP8                    caps</p>
  <p>I am working in excel and not sure if this can be acheived through excel or with R.</p>
  <p>Thanks for the help.</p>