title: If cell value starts with a specific set of numbers, replace data
body: <p>My cell values are strings of numbers (always greater than 5 numbers in a cell, ie 67391853214, etc.)</p>
  
  <p>If a cell starts with three specific numbers (ie 673 in a cell value 67391853214) I want the data in the cell to be replaced with a different value (if 673 are the first numbers, replace entire cell value with "790")</p>
  
  <p>I know there's a way to use an asterick to use only part of the cell value but I'm not 100% on the syntax. This is the current code I have, but it's searching for specifically "###*", not values that start with "###". Any and all help is greatly appreciated!</p>
  
  <pre><code>lastRow = Range("A" &amp; Rows.Count).End(xlUp).Row
  colNum = WorksheetFunction.Match("Number", Range("A1:CC1"), 0)
  For Each c In Range(Cells(2, colNum), Cells(lastRow, colNum))  
  If c.Value = "614*" _
          Or c.Value = "626*" _
          Or c.Value = "618*" _
          Or c.Value = "609*" _
          Or c.Value = "605*" Then
              c.Value = "737"
  </code></pre>
  
  <p>`       </p>