Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Hi! Didn't know the formula used in the solution so I used a different one. Thanks for the solution, learned a new formula.
-Mariel
Takeaways: two functions, namely, StripQuotes, and Trim. It feels to me stripquotes function is a simplifed trim function, which is used for quotes.
Again, I have used a not so smart method. but good to try out the text input tool, and find-replace tool.