title: Camel case converter in an excel
body: <p>I am trying to convert a field in an excel sheet (e.g. REC_LEN) to camel case. I am using this formula to do that </p>
  
  <pre><code>=LEFT(A1) &amp; RIGHT(SUBSTITUTE(PROPER(A1),"_",""), LEN( SUBSTITUTE(A1,"_",""))-1) 
  </code></pre>
  
  <p>This is giving me results like RecLen. I want to convert my first letter to lowercase too (The expected output is recLen). Can somebody help me out with this? I am not too familiar with excel formulae. Not sure if this has been already asked before but any help is much appreciated.</p>