title: Mass convert latitude/longitude to decimal format as an excel VBA?
body: <p>I have a spreadsheet that has latitude in column A and longitude in column B, in the format: 34° 3' 8.0460.</p>
  
  <p>I want to be able to run a tool that when you press a button (after pasting data into columns A and B), will return columns C and D, which are the decimal values of A and B, respectively.</p>
  
  <p>I’ve seen some functions that you can call individual cells to get results, but I need to be able to convert hundreds of cells in one click. Maybe include a “convert” button that runs the script?</p>
  
  <p>Any ideas on a VBA code that could do the trick?</p>
  
  <p>I’m fairly new to using coding.</p>