title: Finding specific string typed together with other characters
body: <p>I am trying to verify if a number (7) or string ('7') exist in one of the columns, and if they do to return a message box. For example, consider the following data:</p>
  
  <pre><code>Name    Cod
  A       7
  A       3
  B       4
  C       7;3
  D       7 3
  D       7, 3
  F       7 - 3 
  F       5
  </code></pre>
  
  <p>I can find the number 7 in the column Cod, but cannot check when it comes together with other numbers and symbols like comma, dash, semicolon, etc. The following code works for cell B2:</p>
  
  <pre><code>Dim N As Range
  
  Sub Find_7_string()
  
      msg = ""
  
      For Each N In Range("A2", Range("A2").End(xlDown))
          If N.Offset(, 1) = 7 Then
          msg = msg &amp; "There should not be 7 in column Cod" &amp; vbLf
              Exit For
          End If
      Next N
  
      If Len(msg) &gt; 1 Then
          MsgBox msg
      End If
  
  End Sub
  </code></pre>
  
  <p>But it doesn't work for cells B5, B6, B7 and B8. </p>
  
  <p>How could I also verify the character '7' when it is a string typed together with other characters?</p>