Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI 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!
I like this beginner workflow. Can be used in some many different formatting areas.
First challenge completed, hopefully successfully, under the hideous wing of @mceleavey.