I was trying to use a formula to replace the quotes, but was running into issues. I happened to notice in the solution that when replacing quotes you need to have an apostrophe on either side of the quote whereas normally when replacing text you need to have quotes on either side. Once I discovered this, I was able to use a formula tool with REGEX_Replace formula.
I DID IT!! :D
Took me a visit to the community to see if there was an easier way to remove the quotes (which of course there is!) but I learned something new today and I completed my first challenge! WOOT!
First challenge completed, hopefully successfully, under the hideous wing of @mceleavey.