title: How to mask accounts in excel sheet?
body: <p>Im working for a bank where customer accounts with varied lengths need to masked in excel sheet.</p>
  
  <p>Is there any macro or formatting method which could help me doing this?</p>
  
  <p>Eg:</p>
  
  <pre><code>Cell No  Value:
  
  A10      46579094628
  A11      NL6539123747796621
  
  This would turn to
  
  A10      46XXXXXXX28
  A11      NLXXXXXXXXXXXXXX21
  </code></pre>
  
  <p>I want to keep 1st 2 digits and last 2 or 3 digits intact. Please advise.</p>