title: Get all rows to the same format standard
body: <p>I currently have some rows that are not formatted properly. Essentially, I am storing chocolates in the following format XXXX CHOC00X. So, for example, in the list below Bounty CHOC001 is valid. But then any chocolates that don't follow this format are invalid. Please see list below:</p>
  <pre><code>Chocolates
  Bounty CHOC001
  twIX CHOC002
  snickers CHOC003
  Mars choc004
  kinder Bueno ch0c005
  dairymilk cHOc006
  wisPa choC007
  </code></pre>
  <p>As you can see entries like <code>twIX CHOC002</code> and <code>kinder Bueno ch0c005</code> are invalid. I want something like this:</p>
  <pre><code>Chocolates
  Bounty CHOC001
  Twix CHOC002
  Snickers CHOC003
  Mars CHOC004
  Kinder Bueno CHOC005
  Dairymilk CHOC006
  Wispa CHOC007
  </code></pre>
  <p>I tried using this formula <code>PROPER()</code> but then it only capitalises each word which is good by then <code>CHOC001</code> would then instead be <code>Choc001</code>. Not sure if there is a way to apply the same conditional formatting of the first column.</p>
  <p>Thanks</p>