title: How in Excel to Remove only 1st comma (exact character, symbol or string)
body: <p>I have numbers witch when is 1000 then has comma "," before hundreds like 1,234,00</p>
  
  <p>How to remove 1st comma or make 2nd to appear so it would be <strong>1234,00</strong> or in excel as it works as number if has only space then with space or comma?</p>
  
  <p>I have formula so far for getting number </p>
  
  <pre><code>=MID(LEFT($A604;FIND(" on ";$A604)-1);FIND("?";$A604)+1;LEN($A604))*1
  </code></pre>
  
  <p>And for removing all i put it in substitute to remove commas but that makes number wrong higher like 123400</p>
  
  <pre><code>=SUBSTITUTE(MID(LEFT($A604;FIND(" on ";$A604)-1);FIND("?";$A604)+1;LEN($A604));",";"")*1
  </code></pre>