title: Trying to split data from one cell into multiple cells
body: <p>I'm trying to split data from one cell into multiple cells. A sample line of data would be: </p>
  
  <h1>7/21 6.98 2.18 CR 7/19-7/24</h1>
  
  <p>My goal is to make each piece of data appear in separate columns through a VBA macro. This is the code I have so far </p>
  
  <pre><code>Sub nameTest()
  
      Dim txt As String
      Dim i As Integer
      Dim FullName As Variant
  
      txt = ActiveCell.Value
  
      FullName = Split(txt, " ")
      For i = 0 To UBound(FullName)
          Cells(1, i + 1).Value = FullName(i)
      Next i
  
  End Sub
  </code></pre>
  
  <p>My issue is that I cant figure out a way to make it run on each and every row, rather than just one row. Does anyone know how to do this? thank you for your time and help </p>