title: Macro to count first four characters in a column and give the total count to Text file
body: <p>I am looking for macro which works in counting the first four characters of a word in the column and gives the total count.</p>
  
  <p>For Example:</p>
  
  <p>Column A</p>
  
  <pre><code>tg34pc005
  tg36pc008
  tg34pc006
  </code></pre>
  
  <p>my expectation is macro should give out result</p>
  
  <pre><code>tg34 2
  tg36 1
  </code></pre>