Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #35: Data Cleansing Practice

jrlindem
12 - Quasar

After completing, I scrolled through lots of the other responses and there are so many great and creative ways to solve these four problems.  I used a combination of formula functions and bit of regex:

 

Spoiler
jrlindem_0-1761594335613.png