title: How do I set the contents of an Excel cell equal to a string variable?
body: <p>I am formatting some data I received. I have several hundred names of students in Column A, and for some strange reason there is a random * placed randomly throughout the names. I want to programmatically remove all * characters from all names.</p>
  
  <pre><code> For x = 2 To 300
  
          Dim strStudent as String
  
          //how do i set contents of cell to string strStudent
  
          strStudent = Replace(strStudent, "*", "") //replace * with nothing
  
   Next
  </code></pre>
  
  <p>My question is, how do I set the contents of the cell we are looping through to the strStudent variable?  </p>