Search

Close

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

Completed

My take on Challenge 59

Challenge 59 is done!

challenge 59 JMS solution.PNG

Fun challenge. Not my most elegant solution, now that I've seen others' solutions.

My Solution:

Here's my solution to challenge 59.

I really liked this one!

Solution attached. My pride was telling me to redo this after seeing the solution. But I resisted.

Instead, I consider this a hard lesson on the value of the "tokenize" option in the REGEX tool.

This is my take on the challenge. I think it has limitation of having to hard code the multi-row formula expression to the maximum length of word. This is what I arrived at, working on my own and I think it's pretty good for now.