title: Copy cell data as string and paste into new cell
body: <p>One of the instruments I use at work has an option to record data into Excel. The data it spits out is unreadable in its raw form.</p>
  
  <p>I found if I copy the string that appears in the formula bar (rather than just selecting the cell itself and copying) and paste it into another cell, it expands the data to make it readable.</p>
  
  <p>All the copy/paste macros I found copy the cell into another cell, which in this case preserves the initial formatting.</p>
  
  <p>I need to copy the string, rather than the cell, and paste it into another cell.</p>