title: VBA convert column of sentences to column of single words
body: <p>I have run into a small problem, as probably you can see I am not a master of VBA. 
  My set input like this (all in one column, much longer):</p>
  
  <ol>
  <li>Nice to meet you. </li>
  <li>Nice to meet you too.  </li>
  <li>What is your name?  </li>
  <li>My name is Jack.<br>
  .....</li>
  </ol>
  
  <p>As a result I am looking for: </p>
  
  <ol>
  <li>Nice</li>
  <li>to</li>
  <li>meet</li>
  <li>you.</li>
  <li>Nice</li>
  <li>to</li>
  <li>meet</li>
  <li>you</li>
  <li>too.</li>
  <li>What</li>
  <li>is</li>
  <li>your</li>
  <li>name?</li>
  <li>My<br>
  ...</li>
  </ol>
  
  <p>Perfect reslut would be every sentence separated into unique words without punctuation marks in the list.</p>
  
  <p>The code I have so far is:</p>
  
  <pre><code>Sub splitAddress()
      Dim strAddress As String
      Dim strAddressParts() As String
      Dim numParts As Integer
      Dim lastRow As Long
      Dim rwIndex As Integer
      Dim colIndex As Integer
  
      lastRow = Cells(Rows.Count, 3).End(xlUp).Row
  
      For rwIndex = 2 To lastRow
          strAddress = Range("C" &amp; rwIndex).Value
  
          strAddressParts = Split(strAddress, " ")
          numParts = UBound(strAddressParts) + 1
  
          Range("I2").Resize(numParts).Value = WorksheetFunction.Transpose(strAddressParts)
      Next
  End Sub
  </code></pre>
  
  <p>It seems to be working, but it overwrites the cells. Can you please help me?</p>