title: Finding a specific character with strings of text then changing the formatting of the specific character only
body: <p><b>Requirement </b><br>
  I have an excel sheet with hundreds of rows and columns.  Each cell is filled with random character that are times new roman, size 10, regular.<br>
  I need to find a single character "·" that is randomly placed in some cells and not in others.<br>
  Once I find this character I need to change the format to symbol, size 9, and bold.</p>
  
  <p><b>Problem</b>
  I cannot use the "find all" and "replace all" feature because that changes the entire cell format.  How do I write a code to find and replace/change the "·" symbol format?  I am very amateur with VBA.</p>
  
  <p>Here's what I have attempted, but it does not work.</p>
  
  <pre><code> Sub bnm()
       With Selection.Find
          .ClearFormatting
          .Text = "·"
          .Replacement.ClearFormatting
          .Replacement.Text = "·"
          .Name = "Symbol"
          .FontStyle = "bold"
          .Size = 9
          .Execute Replace:=wdReplaceAll, Forward:=True, _
              Wrap:=wdFindContinue
      End With
  End Sub
  </code></pre>
  
  <p>Please help!  Thank you.</p>