title: How to mass edit the format of cells in a CSV file - Excel 2013
body: <p>Right now I have a CSV file with thousands of URLs. Each row contains a URL in this format: <code>5,google.com</code> and this <code>1750,facebook.com</code>. Each number is a URL count.</p>
  
  <p>Basically I want to change the format to this: <code>http://www.google.com</code> for all URLs so I can import the CSV to a python script and do some crawling on the URLs.</p>
  
  <p>I managed to automatically add <code>http://www.</code> in front of all thousands URLs by custom formatting the cells. But I couldn't get rid of the counting numbers and the <code>,</code> in front of the URLs. Now I'm stuck with this: <code>http://www.1,google.com</code>.</p>
  
  <p>How do I automatically sort these URLs to the desired format as mentioned above? </p>