title: how to extract strings in excel in a specified format using string formula?
body: <pre><code>Tendulkar,Sachin Ramesh  
  "=CONCATENATE(MID(C7,FIND(",",C7)+1,8)," ",LEFT(C7,FIND(",",C7)-1))"  
  </code></pre>
  
  <p>For the above string, I want it as "Sachin R Tendulkar". I had written the above formula and it is working fine. Is there any other way to make dynamically Like instead of counting the characters and specifying it in find function?<br>
  Thanks in advance.</p>