title: How to Replace a Value in a String in Column with a Do Loop in VBA
body: <p>I have a column of telephone numbers.  Some of them contain two continuous hyphen "--" instead of one "-".  I would like to replace the "--" with "-".<br>
  The problem is if the "--" appears only once for each cell, then that's fine, but it may have situations like "----" or "---", or even "-----------".  My hunch is to use a Do While or Until Loop, but I don't know how.  And I think I will need the Find Function, but I don't know how to combine them.<br>
  Can somebody kindly enough help me please?<br>
  Thanks.</p>