title: How do I convert a list of file paths to their short file path, DOS/8,3 format, using a macro in VBA?
body: <p>I have a list of file paths in cells in Excel that locate to sets of folders, example:</p>
  
  <pre><code>**Start:** G:\TSB\Bridge Shared\Bridge Plans\Bridge Plans-SCANNED\2574 35_Long Creek
  </code></pre>
  
  <p><strong>Want this:</strong> G:\TSB\Bridge~1\Bridge~1\Bridge~1\2574 35~1 (I wrote this by hand so it might not be perfect but hopefully you get what I mean)</p>
  
  <p>I have nearly 3000 file paths listed in Excel but would like them to be displayed in the short file path format, DOS or 8.3 format is what it is called I believe. </p>
  
  <p>Basically I have the folder locations listed in column A in Excel, and I want a macro to run that looks at each individual path and converts it to short path version in column B. There has to be some way to do this automatically and not one by one?</p>
  
  <p>Any help would be appreciated, just can't seem to find anything online to get me started as I am a beginner in VBA.</p>