I am trying to write some VBA to copy data to a cell and then to edit the data in that cell. Spefically I am copying information from a CSV file that looks like this: “Some Text” and I want it to look like this: Some Text or =”Some Text”. So I want to be rid of the quotations or simply change it so it is a formula for a string.
