title: Remove paragraph mark from string
body: <p>I have a macro that finds all of the 'Heading 1' styles within my document and lists them in a ComboBox on a UserForm.</p>
  
  <p>My problem is that the Find routine I am using is also selecting the paragraph mark (<strong>¶</strong>) after the text I wish to copy, and that is being displayed in the ComboBox.</p>
  
  <p>How can I remove this from the string? I've tried useing <code>replace()</code>, replacing <code>vbCrLf</code>, <code>vbCr</code>, <code>vbLf</code>, <code>vbNewLine</code>, <code>^p</code>, <code>v</code>, <code>Chr(244)</code> and <code>Asc(244)</code> with <code>""</code>, but nothing has succeeeded. For example -</p>
  
  <pre><code>sanitizedText = Replace(Selection.Text, "^v", "")
  </code></pre>
  
  <p>Can anyone please help with this problem? Thanks.</p>
  
  <p>Here is how my form looks -</p>
  
  <p><img src="https://i.stack.imgur.com/AyJ1Y.png" alt="enter image description here"></p>