title: How to get content from MS word cells with VBA and clean it for Excel
body: <p>I am trying to get content from cells of a MS word document and copy it into an excel document with a macro using VBA.</p>
  
  <p>I am using this function in order to achieve it:</p>
  
  <pre><code>Cells(insertRow, 1) = WorksheetFunction.Clean(.cell(iRow, iCol).Range.Text)
  </code></pre>
  
  <p>But this only brings the text with spaces, without respecting the line jumps (carriage returns).</p>
  
  <p>I have also tried to use both of this:</p>
  
  <pre><code>Cells(insertRow, 1) = WorksheetFunction.Clean(.cell(iRow, iCol).Range)
  </code></pre>
  
  <p>And</p>
  
  <pre><code>Cells(insertRow, 1) = WorksheetFunction.Clean(.cell(iRow, iCol))
  </code></pre>
  
  <p>With the same result.</p>
  
  <p>That would be the main task. I would also like to know if it is possible to change this <a href="https://i.stack.imgur.com/7N2yO.png" rel="nofollow noreferrer">symbol from MS word</a> into something similar in excel.</p>